The column constraint holds a default value of NULL.Įxample: Creating a GLOBAL TEMPORARY TABLE with multiple columns.Ī global temporary table called RETAILERS will be created. The column constraint must also be defined as either NULL or NOT NULL.
The next definition is to specify the datatype of the column. It is used to specify the name of the column to be created in the global temporary table. Table_name: It is used to specify the name of the global temporary table to be created. Syntax: To create a Global Temporary Table with multiple columns.
Syntax: To create a Global Temporary Table with a single column. It contains all the attributes of a table including information about rows and block, triggers, join cardinality, etc. Temporary tables are much like an ordinary table, with an only vital difference of not having foreign keys related to other tables.
0 kommentar(er)
