as-result-table (column-nameFORCOLUMNsystem-column-name) AS(select-statement) WITH NO DATAWITH DATA copy-options EXCLUDING IDENTITYCOLUMN ATTRIBUTESINCLUDING IDENTITYCOLUMN ATTRIBUTESEXCLUDINGCOLUMNDEFAULTSINCLUDINGCOLUMNDEFAULTSUSING TYPE DEFAULTSEXCLUDING IMPLICITLY HIDDEN COLUMN ATTRIBUTESINCLUDING IMPLICITLY HIDD...
表1は、CREATE TABLE ステートメントの column-description の節に、NOT NULL および DEFAULT の節のさまざまな組み合わせを指定する効果を要約しています。 表1. NOT NULL および DEFAULT 文節の組み合わせ指定の影響 NOT NULL:DEFAULT:影響: Specified1 省略する 挿入または更新操作あるいは LOA...
( <table_option> [ ,...n ] ) ] [ ; ] <column_definition> ::=column_name <data_type> [ FILESTREAM ] [ COLLATE collation_name ] [ NULL | NOT NULL ] [ [ CONSTRAINT constraint_name ] DEFAULT constant_expression ] | [ IDENTITY [ ( seed ,increment ) ] [ NOT FOR REPLICATION ] ...
Simple CREATE TABLE syntax (common if not using options): syntaxsql Copy CREATE TABLE { database_name.schema_name.table_name | schema_name.table_name | table_name } ( { <column_definition> } [ ,... n ] ) [ ; ] Full syntax Disk-based CREATE TABLE syntax: syntaxsql Copy CREATE...
CREATE TABLE table_name ( { < column_definition > | < table_constraint > } [ ,...n ] ) < column_definition > ::= { column_name data_type } [ { DEFAULT constant_expression | [ IDENTITY [ ( seed , increment ) ] ] } ] [ ROWGUIDCOL ] [ < column_constraint > [ ...n ] ]...
This example creates a table with an identity column and ageometrycolumnGeomCol1. A third column renders thegeometrycolumn into its Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation, and uses theSTAsText()method. Two rows are then inserted: one row contains aLineStringinstance...
在column-definition、column-constraint、table-constraint、foreign-key 以及 partition-decl 子句中用于指定将创建对象的 dbspace。如果省略 IN 子句,SAP IQ 将会在已为其分配表的 dbspace 中创建相应对象。 指定SYSTEM 和该子句,以将永久表或临时表放在目录存储库中。指定 IQ_SYSTEM_TEMP 以将临时用户对象(表、分区...
An object table is explicitly defined to hold object instances of a particular type. You can also create an object type and then use it in a column when creating a relational table. Tables are created with no data unless a subquery is specified. You can add rows to a table with the...
An object table is explicitly defined to hold object instances of a particular type. You can also create an object type and then use it in a column when creating a relational table. Tables are created with no data unless a subquery is specified. You can add rows to a table with the...