SQL Server、Azure SQL Database、Azure SQL 受控執行個體的語法syntaxsql 複製 CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name ON ( column [ ASC | DESC ] [ ,...n ] ) [ INCLUDE ( column_name [ ,...n ] ) ] [ WHERE <filter_predicate> ] [ WITH ( <relational...
CREATEUNIQUEINDEXindex_name ONtable_name(column1,column2, ...); Note:The syntax for creating indexes varies among different databases. Therefore: Check the syntax for creating indexes in your database. CREATE INDEX Example The SQL statement below creates an index named "idx_lastname" on the "...
syntaxsql 複製 CREATE TYPE [ schema_name. ] type_name AS TABLE ( { <column_definition> [ , ...n ] } | [ ] [ , ...n ] | [ ] [ , ...n ] ) [ WITH ( [ , ...n ] ) ] [ ; ] <column_definition> ::= column_name <data_type> [ COLLATE collation_name ] [ ...
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 | schema...
为SQL Server 内数据库中的表或索引视图创建全文索引。 每个表或索引视图只允许有一个全文索引,并且每个全文索引会应用于单个表或索引视图。 全文索引最多可以包含 1024 个列。Transact-SQL 语法约定语法syntaxsql 复制 CREATE FULLTEXT INDEX ON table_name [ ( { column_name [ TYPE COLUMN type_column_name...
syntaxsql 複製 CREATE [ OR ALTER ] FUNCTION [ schema_name. ] function_name ( [ { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type [ NULL ] [ = default ] [ READONLY ] } [ , ...n ] ] ) RETURNS return_data_type [ WITH <function_option> [ , ...n ] ]...
CREATE INDEX 语句用于对数据库表定义索引。 可以对 XML 数据或关系数据定义索引。 CREATE INDEX 语句还用于创建索引规范(就是用来向优化器指示数据源表具有索引的元数据)。 调用 此语句可以嵌入在应用程序中,也可通过动态 SQL 语句来发出。 它是一个可执行语句,仅当 DYNAMICRULES 运行行为对于程序包有效时才能动态...
6Ifxml-index-specificationis specified,column-nameDESC, INCLUDE, or CLUSTER cannot be specified. xml-index-specification GENERATE KEY USING XMLPATTERN1xmlpattern-clausexmltype-clause Notes: 1The alternative syntax GENERATE KEYS USING XMLPATTERN can be used. ...
If the view definition contains aGROUP BYclause, the key of the unique clustered index can reference only the columns specified in theGROUP BYclause. TheSELECTstatement in the view definition must not contain the following Transact-SQL syntax: ...
CREATE INDEXTYPE Syntax cluster_index_clause index_attributes::= table_index_clause::= bitmap_join_index_clause::= local_partitioned_index::=index_attributes::= index_expr global_partitioned_index::=,local_partitioned_index::=,index_attributes::=,domain_index_clause::=) ...