This documentation is archived and is not being maintained.

CreationScriptOptions Enumeration

Enumerates schema option values for published articles.

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

public enum CreationScriptOptions
public enum CreationScriptOptions
public enum CreationScriptOptions

Member nameDescription
AttemptToDropNonArticleDependenciesAt the Subscriber, attempts to drop dependencies to any objects that are not part of the publication.
ClusteredIndexesIncludes the creation of a corresponding clustered index.
CollationIncludes the definition of a column-level collation.
CustomProceduresIncludes the generation of custom stored procedures. This option is only valid for the TransArticle object. You must also specify InsertCommand, UpdateCommand, and DeleteCommand.
DefaultBindingsIncludes default bindings and creation of the bound defaults.
DisableScriptingObject 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.
DriChecksIncludes the creation CHECK constraints.
DriDefaultsIncludes the creation column defaults.
DriForeignKeysIncludes the creation of foreign key constraints to all referenced tables that are included in the publication.
DriPrimaryKeyIncludes the creation of primary key constraints.
DriUniqueKeysIncludes the creation of unique keys.
ExtendedPropertiesIncludes the extended properties associated with the database object being published.
FileGroupsIncludes the filegroups associated with a partitioned table or index.
FullTextIndexIncludes full-text indexes.
IdentityIncludes 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 Replicating Identity Columns.
IndexPartitioningSchemesIncludes the partition scheme associated with a partitioned index.
KeepTimestampReplicates timestamp columns. Without this option, timestamp columns are created on the Subscriber as binary(16) columns. This option is supported only for TransArticle objects.
MarkReplicatedCheckConstraintsAsNotForReplicationIncludes the NOT FOR REPLICATION clause when creating CHECK constraints so that the constraints are not enforced during synchronization. For more information, see Controlling Constraints, Identities, and Triggers with NOT FOR REPLICATION.
MarkReplicatedForeignKeyConstraintsAsNotForReplicationIncludes the NOT FOR REPLICATION clause when creating FOREIGN KEY constraints so that the constraints are not enforced during synchronization. For more information, see Controlling Constraints, Identities, and Triggers with NOT FOR REPLICATION.
MaxTypesToMatchingNonMaxTypesConverts nvarchar(max), varchar(max), and varbinary(max) to ntext, text, and image data types, which are supported on earlier versions of SQL Server.
NonClusteredIndexesIncludes the creation of nonclustered indexes.
NoXmlSchemaCollectionsXML schema collections bound to xml columns are not included.
PermissionsIncludes permissions defined on the published object.
PrimaryKeyUniqueKeyAsConstraintsGenerates ALTER TABLE statements when replicating constraints.
PrimaryObjectGenerates a creation script (CREATE TABLE, CREATE PROCEDURE, and so on) for the published object.
RuleBindingsIncludes rule bindings and creation of the bound rules.
SchemaGenerates any schemas not already present on the subscriber.
StatisticsIncludes user-defined table statistics.
TablePartitioningSchemeIncludes the partition scheme associated with a partitioned table.
UserDefinedTypesToBaseTypesConverts 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.
UserTriggersIncludes the creation of user-defined triggers.
XmlIndexesIncludes XML indexes.
XmlToNTextxml 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 Publishing Data and Database Objects.

Values of the CreationScriptOptions enumeration are equivalent to values of the @schema_option parameter of sp_addarticle (Transact-SQL) and sp_addmergearticle (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.


Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Show: