CreationScriptOptions Enumeration

Enumerates schema option values for published articles.

Espace de noms: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Syntaxe

'Déclaration
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 Réplication de colonnes d'identité.
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 Contrôle des contraintes, des identités et des déclencheurs avec l'option NOT FOR REPLICATION.
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 Contrôle des contraintes, des identités et des déclencheurs avec l'option NOT FOR REPLICATION.
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.

Notes

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 Publication de données et d'objets de base de données.

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

Microsoft.SqlServer.Replication Namespace
Article.CreationScript Property