database_name defaults to the current database. The login for the current connection must be associated with an existing user ID in the database specified by database_name, and that user ID must have CREATE TABLE permissions.
The name of the database in which the table is created. database_name must specify the name of an existing database. If not specified, database_name defaults to the current database. The login for the current connection must be associated with an existing user ID in the database specified...
The name of the database in which the table is created. database_name must specify the name of an existing database. If not specified, database_name defaults to the current database. The login for the current connection must be associated with an existing user ID in the database specified...
You cannot specify CACHE for an index-organized table. However, index-organized tables implicitly provide CACHE behavior. NOCACHE For data that is not accessed frequently, this clause indicates that the blocks retrieved for this table are placed at the least recently used end of the LRU list in...
To create a relational table in your own schema, you must have the CREATE TABLE system privilege. To create a table in another user's schema, you must have the CREATE ANY TABLE system privilege. Also, the owner of the schema to contain the table must have either space quota on the tabl...
CreateTable CreateTrigger CreateType CreateUser CreateView CreateXmlIndex CreateXmlSchemaCollection DdlApplicationRoleEventsEvents DdlAssemblyEventsEvents DdlAsymmetricKeyEventsEvents DdlAuthorizationDatabaseEventsEvents DdlBrokerPriorityEventsEvents DdlCertificateEventsEvents DdlColumnEncryptionK...
System-maintained, user-maintained, federated_tool-maintained, and replication-maintained materialized query tables (shadow tables) are referred to by the common term materialized query table, unless a need exists to identify each one separately. IF NOT EXISTS Specifies that no error message is shown...
similar to the table on which the trigger is defined, that is, the table on which the user action is tried. The deleted and inserted tables hold the old values or new values of the rows that may be changed by the user action. For example, to retrieve all values in the deleted table...
Table options are used to optimize the behavior of the table. In most cases, you do not have to specify any of them. These options apply to all storage engines unless otherwise indicated. Options that do not apply to a given storage engine may be accepted and remembered as part of the ...
When you run a CREATE TABLE statement that contains an AS full-select clause, the statement is processed as two separate statements: a CREATE TABLE and an INSERT or SELECT.