syntaxsql复制 -- Create a new table.CREATETABLE{database_name.schema_name.table_name|schema_name.table_name|table_name} ( {column_name<data_type>[<column_options>] } [ ,...n ] ) [WITH(<table_option>[ ,...n ] ) ] [;]<column_options>::=[COLLATEWindows_collation_name] [NULL|...
{ <collation_name> | database_default } ] [ FILETABLE_PRIMARY_KEY_CONSTRAINT_NAME = <constraint_name> ] [ FILETABLE_STREAMID_UNIQUE_CONSTRAINT_NAME = <constraint_name> ] [ FILETABLE_FULLPATH_UNIQUE_CONSTRAINT_NAME = <constraint_name> ] [ SYSTEM_VERSIONING = ...
存储在 tempdb 的 sysobjects 表中的临时表,其全名由 CREATE TABLE 语句中指定的表名和系统生成的数字后缀组成。为了允许追加后缀,为本地临时表指定的 table_name 不能超过 116 个字符。 除非使用 DROP TABLE 显式删除临时表,否则临时表将在退出其作用域时由系统自动删除: 当存储过程完成时,将自动删除在存储过程...
{ <collation_name> | database_default } ] [ FILETABLE_PRIMARY_KEY_CONSTRAINT_NAME = <constraint_name> ] [ FILETABLE_STREAMID_UNIQUE_CONSTRAINT_NAME = <constraint_name> ] [ FILETABLE_FULLPATH_UNIQUE_CONSTRAINT_NAME = <constraint_name> ] [ SYSTEM_VERSIONING = ON [ ( HISTORY_TABLE = ...
{ <collation_name> | database_default } ] [ FILETABLE_PRIMARY_KEY_CONSTRAINT_NAME = <constraint_name> ] [ FILETABLE_STREAMID_UNIQUE_CONSTRAINT_NAME = <constraint_name> ] [ FILETABLE_FULLPATH_UNIQUE_CONSTRAINT_NAME = <constraint_name> ] [ SYSTEM_VERSIONING = ON [ ( HISTORY_TABLE = ...
syntaxsql复制 -- Create a new external tableCREATEEXTERNALTABLE{database_name.schema_name.table_name|schema_name.table_name|table_name} (<column_definition>[ ,...n ] )WITH(LOCATION='folder_or_filepath',DATA_SOURCE=external_data_source_name, [FILE_FORMAT=external_file_format_name] [ ,<rej...
WITH table-option- 可选-一个或多个表选项(如一个或多个%CLASSPARAMETER子句或STORAGETYPE子句)的逗号分隔列表。 COLLATE sqlcollation- 可选-指定以下SQL排序规则类型之一:%Exact、%Minus、%Plus、%SPACE、%SQLSTRING、%SQLUPPER、%TRUNCATE或%MVR。默认值为名称空间默认排序规则(除非更改,否则为%SQLUPPER)。%SQL...
syntaxsql复制 -- Create a new external tableCREATEEXTERNALTABLE{database_name.schema_name.table_name|schema_name.table_name|table_name} (<column_definition>[ ,...n ] )WITH(LOCATION='folder_or_filepath',DATA_SOURCE=external_data_source_name, [FILE_FORMAT=external_file_format_name] [ ,<rej...
[ WITH ( <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 ...
syntaxsql 複製 CREATE [ OR ALTER ] FUNCTION [ schema_name. ] function_name ( { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type [ NULL ] [ = default ] } [ , ...n ] ) RETURNS TABLE <clr_table_type_definition> [ WITH <clr_function_option> [ , ...n ] ...