GLOBAL TEMPORARY views are tied to a system preserved temporary database global_temp. IF NOT EXISTS. Creates a view if it does not exist. view_identifier. Specifies a view name, which may be ...

A view is a virtual table that contains the result of a SQL query. You can create a view using the CREATE VIEW statement, followed by a name and a query. For example, you can create a view that ...

The CREATE VIEW statement saves a SELECT statement as a queryable object, similar to a table. Views in TiDB are non-materialized. This means that as a view is queried, TiDB will internally rewrite the ...

When you use this form, a table is physically created as the statement is executed. The newly created table does not reflect subsequent changes in the underlying tables (in the query-expression). If ...