CreatePartitionSchemeStatement.FileGroups Property Reference Feedback Definition Namespace: Microsoft.SqlServer.TransactSql.ScriptDom Assembly: Microsoft.SqlServer.TransactSql.ScriptDom.dll Package: Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0 Filegroup names (can be string lit...
CreatePartitionSchemeStatement 构造函数 属性 FileGroups IsAll 名称 PartitionFunction 方法 CreateProcedureStatement CreateQueueStatement CreateRemoteServiceBindingStatement CreateResourcePoolStatement CreateRoleStatement CreateRouteStatement CreateRuleStatement CreateSchemaStatement CreateSearchPropertyListStatemen...
FileGroupOrPartitionScheme.Name Property Reference Feedback Definition Namespace: Microsoft.SqlServer.TransactSql.ScriptDom Assembly: Microsoft.SqlServer.TransactSql.ScriptDom.dll Package: Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0 Can be an identifier or literal of type string. C#...
创建关系索引的语法: CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name ON ( column [ ASC | DESC ] [ ,...n ] ) [ INCLUDE ( column_name [ ,...n ] ) ] [ WITH ( <relational_index_option> [ ,...n ] ) ] [ ON { partition_scheme_name ( column_name ) | fi...
2.2.8、删除原表 DROPTABLESales.SalesOrderHeader 2.2.9、删除分区方案和分区函数 DROPPARTITION SCHEME SalesOrderHeader_OrderDateDROPPARTITIONFUNCTIONSalesOrderHeader_OrderDate 2.2.10重命名表名 EXECSP_RENAME'[Sales].[SalesOrderHeader_Temp]','SalesOrderHeader'...
DROPTABLESales.SalesOrderHeader 1. 2.2.9、删除分区方案和分区函数 DROPPARTITION SCHEME SalesOrderHeader_OrderDateDROPPARTITIONFUNCTIONSalesOrderHeader_OrderDate 1. 2. 2.2.10重命名表名 EXECSP_RENAME'[Sales].[SalesOrderHeader_Temp]','SalesOrderHeader' 1....
每个SQL Server 2005数据库至少具有两个操作系统文件:一个数据文件和一个日志文件。数据文件包含数据和对象,例如表、索引、存储过程和视图。日志文件包含恢复数据库中的所有事务所需的信息。可以将数据文件集合起来,放到文件组中,用于帮助数据布局和管理任务,例如备份和还原操作。
13144 16 否 partition scheme 13145 16 否 加密 13146 16 否 signature 13147 16 否 password 13148 16 否 rename 13149 16 否 结束对话 13150 16 否 END CONVERSATION WITH ERROR 13151 16 否 MOVE CONVERSATION 13152 16 否 接收已编序的消息 13153 16 否 接收结...
10050192ALTER_PARTITION_FUNCTION 10050191CREATE_PARTITION_FUNCTION 10050193DROP_PARTITION_FUNCTION 1004910051DDL_PARTITION_SCHEME_EVENTS 10051195ALTER_PARTITION_SCHEME 10051194CREATE_PARTITION_SCHEME 10051196DROP_PARTITION_SCHEME 1001610055DDL_PLAN_GUIDE_EVENTS ...
CreatePartitionSchemeStatement CreateProcedureStatement CreateQueueStatement CreateRemoteServiceBindingStatement CreateResourcePoolStatement CreateRoleStatement CreateRouteStatement CreateRuleStatement CreateSchemaStatement CreateSearchPropertyListStatement CreateSecurityPolicyStatement CreateSelectiveXmlInde...