CreationScriptOptions Enumeration
Enumerates schema option values for published articles.
네임스페이스: Microsoft.SqlServer.Replication
어셈블리: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)
구문
‘선언
Public Enumeration CreationScriptOptions
public enum CreationScriptOptions
public enum class CreationScriptOptions
public enum CreationScriptOptions
public enum CreationScriptOptions
Members
| Member name | Description |
|---|---|
| AttemptToDropNonArticleDependencies | At the Subscriber, attempts to drop dependencies to any objects that are not part of the publication. |
| ClusteredIndexes | Includes the creation of a corresponding clustered index. |
| Collation | Includes the definition of a column-level collation. |
| CustomProcedures | Includes the generation of custom stored procedures. This option is only valid for the TransArticle object. You must also specify InsertCommand, UpdateCommand, and DeleteCommand. |
| DefaultBindings | Includes default bindings and creation of the bound defaults. |
| DisableScripting | Object creation scripts are not generated by the Snapshot Agent. You must specify a user-supplied script file to define the object at the Subscriber for CreationScript. |
| DriChecks | Includes the creation CHECK constraints. |
| DriDefaults | Includes the creation column defaults. |
| DriForeignKeys | Includes the creation of foreign key constraints to all referenced tables that are included in the publication. |
| DriPrimaryKey | Includes the creation of primary key constraints. |
| DriUniqueKeys | Includes the creation of unique keys. |
| ExtendedProperties | Includes the extended properties associated with the database object being published. |
| FileGroups | Includes the filegroups associated with a partitioned table or index. |
| FullTextIndex | Includes full-text indexes. |
| Identity | Includes the creation of identity columns. This option is supported only for TransArticle objects and only for Microsoft SQL Server 2005 and later releases. For more information, see ID 열 복제. |
| IndexPartitioningSchemes | Includes the partition scheme associated with a partitioned index. |
| KeepTimestamp | Replicates timestamp columns. Without this option, timestamp columns are created on the Subscriber as binary(16) columns. This option is supported only for TransArticle objects. |
| MarkReplicatedCheckConstraintsAsNotForReplication | Includes the NOT FOR REPLICATION clause when creating CHECK constraints so that the constraints are not enforced during synchronization. For more information, see NOT FOR REPLICATION으로 제약 조건, ID 및 트리거 제어. |
| MarkReplicatedForeignKeyConstraintsAsNotForReplication | Includes the NOT FOR REPLICATION clause when creating FOREIGN KEY constraints so that the constraints are not enforced during synchronization. For more information, see NOT FOR REPLICATION으로 제약 조건, ID 및 트리거 제어. |
| MaxTypesToMatchingNonMaxTypes | Converts nvarchar(max), varchar(max), and varbinary(max) to ntext, text, and image data types, which are supported on earlier versions of SQL Server. |
| NonClusteredIndexes | Includes the creation of nonclustered indexes. |
| NoXmlSchemaCollections | XML schema collections bound to xml columns are not included. |
| Permissions | Includes permissions defined on the published object. |
| PrimaryKeyUniqueKeyAsConstraints | Generates ALTER TABLE statements when replicating constraints. |
| PrimaryObject | Generates a creation script (CREATE TABLE, CREATE PROCEDURE, and so on) for the published object. |
| RuleBindings | Includes rule bindings and creation of the bound rules. |
| Schema | Generates any schemas not already present on the subscriber. |
| Statistics | Includes user-defined table statistics. |
| TablePartitioningScheme | Includes the partition scheme associated with a partitioned table. |
| UserDefinedTypesToBaseTypes | Converts user-defined data types columns at the Publisher to base SQL Server data type columns at the Subscriber. This option is not supported for non-SQL Server Publishers. |
| UserTriggers | Includes the creation of user-defined triggers. |
| XmlIndexes | Includes XML indexes. |
| XmlToNText | xml columns are replicated to the Subscriber as ntext. |
주의
The schema options for an article control how the published object will created at the Subscriber, and affect how the snapshot script files are generated. For more information, see 데이터 및 데이터베이스 개체 게시.
Values of the CreationScriptOptions enumeration are equivalent to values of the @schema_option parameter of sp_addarticle(Transact-SQL) and sp_add_targetservergroup(Transact-SQL).
The CreationScriptOptions enumeration supports the FlagsAttribute option which allows bitwise combination of enumeration values.
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
플랫폼
개발 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
대상 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
참고 항목
참조
Microsoft.SqlServer.Replication Namespace
Article.CreationScript Property