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...
Transact-SQL 語法慣例 語法 syntaxsql 複製 CREATE SPATIAL INDEX index_name ON ( spatial_column_name ) { <geometry_tessellation> | <geography_tessellation> } [ ON { filegroup_name | "default" } ] [;] ::= { database_name.schema_name.table_name | sc...
CREATE ROLE (Transact-SQL) CREATE ROUTE (Transact-SQL) CREATE RULE (Transact-SQL) CREATE SCHEMA (Transact-SQL) CREATE SERVER AUDIT (Transact-SQL) CREATE SERVER AUDIT SPECIFICATION (Transact-SQL) CREATE SERVICE (Transact-SQL) CREATE SPATIAL INDEX (Transact-SQL) ...
If the view definition contains a GROUP BY clause, the key of the unique clustered index can reference only the columns specified in the GROUP BY clause. The SELECT statement in the view definition must not contain the following Transact-SQL syntax: Expand table Transact-SQL functionPossible al...
CREATE ROLE (Transact-SQL) CREATE ROUTE (Transact-SQL) CREATE RULE (Transact-SQL) CREATE SCHEMA (Transact-SQL) CREATE SERVER AUDIT (Transact-SQL) CREATE SERVER AUDIT SPECIFICATION (Transact-SQL) CREATE SERVICE (Transact-SQL) CREATE SPATIAL INDEX (Transact-SQL) ...
-- SQL Server Syntax-- Trigger on an INSERT, UPDATE, or DELETE statement to a-- table (DML Trigger on memory-optimized tables)CREATE[ORALTER]TRIGGER[schema_name. ]trigger_nameON{ table } [WITH<dml_trigger_option>[ ,...n ] ] {FOR|AFTER} { [INSERT] [ , ] [UPDATE] [ , ] [DEL...
Syntaxsyntaxsql نسخ CREATE FULLTEXT INDEX ON table_name [ ( { column_name [ TYPE COLUMN type_column_name ] [ LANGUAGE language_term ] [ STATISTICAL_SEMANTICS ] } [ , ...n ] ) ] KEY INDEX index_name [ ON <catalog_filegroup_option> ] [ WITH ( <with_option> [ , ......
syntaxsql 复制 CREATE SPATIAL INDEX index_name ON ( spatial_column_name ) { <geometry_tessellation> | <geography_tessellation> } [ ON { filegroup_name | "default" } ] [;] ::= { database_name.schema_name.table_name | schema_name.table_name | table_name } <geometry_tess...
CREATE INDEX 语句用于对数据库表定义索引。 可以对 XML 数据或关系数据定义索引。 CREATE INDEX 语句还用于创建索引规范(就是用来向优化器指示数据源表具有索引的元数据)。 调用 此语句可以嵌入在应用程序中,也可通过动态 SQL 语句来发出。 它是一个可执行语句,仅当 DYNAMICRULES 运行行为对于程序包有效时才能动态...
Syntax CREATE [ UNIQUE ] INDEXindex ONtable(field[ASC|DESC][,field[ASC|DESC], ...]) [WITH { PRIMARY | DISALLOW NULL | IGNORE NULL }] The CREATE INDEX statement has these parts: Remarks To prohibit duplicate values in the indexed field or fields of different records, use the UNIQUE res...