Transact-SQL 語法慣例注意 Azure Synapse Analytics 的無伺服器 SQL 集區不支援此語法。語法syntaxsql 複製 CREATE SYMMETRIC KEY key_name [ AUTHORIZATION owner_name ] [ FROM PROVIDER provider_name ] WITH [ <key_options> [ , ... n ] | ENCRYPTION BY <encrypting_mechanism> [ , ... n ] ] ...
Azure SQL 資料庫 語法: syntaxsql CREATESYNONYM[schema_name_1. ]synonym_nameFOR::={ [database_name. [schema_name_2 ] . |schema_name_2. ]object_name} 引數 schema_name_1 指定建立同義字的結構描述。 如果未指定schema_name,SQLServer 會使用目前使用者的預設架構。 synonym_name 新同義...
Use the out_of_line_constraint syntax to define an integrity constraint as part of the table definition.Note: You must specify a PRIMARY KEY constraint for an index-organized table, and it cannot be DEFERRABLE.See Also: the syntax description of out_of_line_constraint in the constraints...
Azure SQL 数据库语法: syntaxsql CREATESYNONYM[schema_name_1. ]synonym_nameFOR::={ [database_name. [schema_name_2 ] . |schema_name_2. ]object_name} 参数 schema_name_1 指定创建同义词所使用的架构。 如果未指定schema_name,SQL Server 会使用当前用户的默认架构。 synonym_name 新同义...
The syntax for the SQL create table statement is: CREATE[schema_name.]table_name(column_name data_type[NULL|NOTNULL][inline_constraint][DEFAULTdefault_value],...out_of_line_constraints); The parameters or values mentioned in this syntax are: ...
To create a private synonym in another user's schema, you must have CREATE ANY SYNONYM system privilege. To create a PUBLIC synonym, you must have CREATE PUBLIC SYNONYM system privilege. Syntaxcreate_synonym::= Text description of create_synonym ...
如需語法慣例的詳細資訊,請參閱Transact-SQL 語法慣例。 syntaxsql CREATEDATABASEdatabase_name[CONTAINMENT= {NONE|PARTIAL} ] [ON[PRIMARY]<filespec>[ ,...n ] [ ,<filegroup>[ ,...n ] ] [LOGON<filespec>[ ,...n ] ] ] [COLLATEcollation_name] [WITH[,...n ] ] [;]::={FILESTREAM(<...
Syntax 引數 備註 記憶體優化數據表類型 顯示其他 3 個 適用於:Microsoft Fabric 中的 SQL ServerAzure SQL 資料庫 Azure SQL 受控執行個體 SQL 資料庫 在SQL Server 或 Azure SQL Database 的目前資料庫中建立別名資料類型或使用者定義型別。 別名數據類型的實作是以原生系統類型 資料庫引擎 為基礎。
Transact-SQL 语法约定语法适用于 SQL Server、Azure SQL 数据库和 Azure SQL 托管实例的语法syntaxsql 复制 CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name ON ( column [ ASC | DESC ] [ ,...n ] ) [ INCLUDE ( column_name [ ,...n ] ) ] [ WHERE <filter_predica...
syntaxsql 複製 CREATE TABLE { database_name.schema_name.table_name | schema_name.table_name | table_name } ( { <column_definition> | [ ] [ ,... n ] | [ ] [ ,... n ] } [ PERIOD FOR SYSTEM_TIME ( system_start_time_column_name , system_end_time_column_name ) ] ) ...