View

How it is used

Used to hide complex joins, give reporting teams a simple interface or limit which columns a user can see. A materialized view is different: it stores the result physically and must be refreshed. You create, drop and query views.

Example sentences

1. The finance team queries a view that joins orders, payments and refunds.

2. We refresh the materialized view every hour because the base query is expensive.

Common collocations

• create a view
• materialized view
• refresh a view
• query a view

Related terms

• tableA structure in a relational database that stores data about one kind of thing in rows and columns, for example all customers or all orders.
• SELECT statementThe SQL statement that reads data from one or more tables and returns the matching rows without changing anything in the database.
• privilegeA permission that allows a database user or role to do a specific action, such as reading a table, inserting rows or creating new objects.
• stored procedureA named block of SQL code saved inside the database that can take parameters and be run again and again with a single call.

This word in other fields

The same English word can have a different meaning in another field:

• view · Software Engineering

More terms: Tables, Schemas and Database Objects

• row
• column
• schema
• record
• data type
• NULL
• CREATE TABLE
• ALTER TABLE
• default value
• trigger
• migration