Compartir a través de

ScriptOption Miembros

The ScriptOption object represents the SQL Server script options that can be included in scripting options that are set by using the ScriptingOptions object.

El tipo ScriptOption expone los siguientes miembros.

Métodos

  Nombre Descripción
Método publicoMiembro estático Add Adds two ScriptOption objects to create a ScriptOptions object.
Método publicoMiembro estático BitwiseOr Combines two ScriptingOptions object using a Bitwise OR operation.
Método publico Equals Returns a Boolean value that specifies if two ScriptOptions are equal. (Invalida Object. . :: . .Equals(Object).)
Método protegido Finalize (Se hereda de Object).
Método publico GetHashCode Returns the hash code for this object. (Invalida Object. . :: . .GetHashCode() () () ().)
Método publico GetType (Se hereda de Object).
Método protegido MemberwiseClone (Se hereda de Object).
Método publico ToString Returns a string that represents the current object. (Invalida Object. . :: . .ToString() () () ().)

Principio

Operadores

  Nombre Descripción
Operador públicoMiembro estático Addition Creates a set of scripting options by performing an addition operation on two ScriptOption objects.
Operador públicoMiembro estático BitwiseOr Creates a set of scripting options by performing a bitwise OR operation on two ScriptOption objects.
Operador públicoMiembro estático Implicit Widening Implicit Implicit Implicit(ScriptOption to ScriptingOptions)

Principio

Propiedades

  Nombre Descripción
Propiedad públicaMiembro estático AgentAlertJob Gets an object that specifies whether to include SQL Server Agent alerts and jobs in the script. 
Propiedad públicaMiembro estático AgentJobId Gets an object that specifies whether to include SQL Server Agent alerts and jobs in the script. 
Propiedad públicaMiembro estático AgentNotify Gets an object that specifies whether to include notifications for any SQL Server Agent alerts that in the script. 
Propiedad públicaMiembro estático AllowSystemObjects Gets an object that specifies whether system objects can be scripted or not.
Propiedad públicaMiembro estático AnsiFile Gets an object that specifies whether the script uses multibyte characters and requires code page 1252 to evaluate characters meaning.
Propiedad públicaMiembro estático AnsiPadding Gets an object that specifies whether the generated script contains the Transact-SQL statements SET ANSI-PADDING ON and SET ANSI-PADDING OFF before and after the CREATE TABLE statement, respectively.
Propiedad públicaMiembro estático AppendToFile Gets an object that specifies whether the script is appended to the end of the output file or overwrites it.
Propiedad públicaMiembro estático Bindings Gets an object that specifies whether the binding statements sp_binddefault and sp_bindrule are included in the generated script. This property applies only when scripting a Microsoft SQL Server table.
Propiedad públicaMiembro estático ChangeTracking Gets the ChangeTracking property value.
Propiedad públicaMiembro estático ClusteredIndexes Gets an object that specifies whether statements that define clustered indexes are included in the generated script.
Propiedad públicaMiembro estático ContinueScriptingOnError Gets an object value that specifies whether the scripting operation continues after an error is encountered.
Propiedad públicaMiembro estático ConvertUserDefinedDataTypesToBaseType Gets an object value that specifies whether user-defined data types are converted to the most appropriate SQL Server base data types in the generated script. 
Propiedad públicaMiembro estático DdlBodyOnly Gets an object value that specifies whether to script only the text definition for data definition language (DDL) objects that have a text body, such as stored procedures and triggers.
Propiedad públicaMiembro estático DdlHeaderOnly Gets an object value that specifies whether to script only the header information for data definition language (DDL) objects that have a text body, such as stored procedures and triggers.
Propiedad públicaMiembro estático Default Gets an object value that specifies whether the creation of the referenced object is included in the generated script.
Propiedad públicaMiembro estático DriAll Gets an object value that specifies whether the DRI objects are included in the generated script.
Propiedad públicaMiembro estático DriAllConstraints Gets an object value that specifies whether all DRI constraints are included in the generated script.
Propiedad públicaMiembro estático DriAllKeys Gets an object value that specifies whether all DRI keys (DriForeignKeys, DriPrimaryKey, DriUniqueKeys) are included in the generated script.
Propiedad públicaMiembro estático DriChecks Gets an object value that specifies whether column-specific dependency relationships defined in check constraints with enforced declarative referential integrity are included in the script.
Propiedad públicaMiembro estático DriClustered Gets an object value that specifies whether dependency relationships defined in clustered indexes with enforced declarative referential integrity are included in the script.
Propiedad públicaMiembro estático DriDefaults Gets an object value that specifies whether dependency relationships defined in defaults with enforced declarative referential integrity are included in the script.
Propiedad públicaMiembro estático DriForeignKeys Gets an object value that specifies whether dependency relationships defined in foreign keys with enforced declarative referential integrity are included in the script.
Propiedad públicaMiembro estático DriIncludeSystemNames Gets an object value that specifies whether the system generated constraint names used to enforce declarative referential integrity are included in the script.
Propiedad públicaMiembro estático DriIndexes Gets an object value that specifies whether PRIMARY KEY constraints using a unique index to implement the declarative referential integrity are included in the generated script.
Propiedad públicaMiembro estático DriNonClustered Gets an object value that specifies whether dependency relationships defined in non-clustered indexes with enforced declarative referential integrity are included in the script.
Propiedad públicaMiembro estático DriPrimaryKey Gets an object value that specifies whether dependency relationships defined in primary keys with enforced declarative referential integrity are included in the script.
Propiedad públicaMiembro estático DriUniqueKeys Gets an object value that specifies whether dependency relationships defined in unique keys with enforced declarative referential integrity are included in the script.
Propiedad públicaMiembro estático DriWithNoCheck Gets an object value that specifies whether the no check statement is included in the script.
Propiedad públicaMiembro estático EnforceScriptingOptions Gets an object value that specifies whether the application of all scripting options is enforced for text base objects, such as SchemaQualify.
Propiedad públicaMiembro estático ExtendedProperties Gets an object value that specifies whether extended object properties are included in the generated script.
Propiedad públicaMiembro estático FullTextCatalogs Gets an object value that specifies whether full-text catalogs are included in the generated script.
Propiedad públicaMiembro estático FullTextIndexes Gets an object value that specifies whether full-text indexes are included in the generated script.
Propiedad públicaMiembro estático FullTextStopLists Gets an object value that specifies whether full-text stop lists are included in the generated script.
Propiedad públicaMiembro estático IncludeDatabaseContext Gets an object value that specifies whether database content is included in the generated script.
Propiedad públicaMiembro estático IncludeDatabaseRoleMemberships Gets the IncludeDatabaseRoleMemberships property value.
Propiedad públicaMiembro estático IncludeFullTextCatalogRootPath Gets the IncludeFullTextCatalogRootPath property value.
Propiedad públicaMiembro estático IncludeHeaders Gets an object that specifies whether the generated script is prefixed with a header containing information including the date and time of generation.
Propiedad públicaMiembro estático IncludeIfNotExists Gets an object that specifies whether to check the existence of an object before including it in the script.
Propiedad públicaMiembro estático Indexes Gets an object that specifies whether indexes are included in the generated script.
Propiedad públicaMiembro estático LoginSid Gets an object value that specifies whether assemblies are included in the generated script.
Propiedad públicaMiembro estático NoAssemblies Gets an object that specifies whether assemblies are excluded from the generated script.
Propiedad públicaMiembro estático NoCollation Gets an object value that specifies whether to include the collection in the generated script if the server is running SQL Server 7.0 or later.
Propiedad públicaMiembro estático NoCommandTerminator Gets an object value that specifies whether individual Transact-SQL statements are delimited in the generated script.
Propiedad públicaMiembro estático NoExecuteAs Gets an object value that specifies whether the EXECUTE AS options for stored procedures and user-defined functions are included in the script.
Propiedad públicaMiembro estático NoFileGroup Gets an object value that specifies whether to include the 'ON <filegroup>' clause in the generated script.
Propiedad públicaMiembro estático NoFileStream Gets an object that specifies whether to include the FILESTREAM_ON clause when you create VarBinaryMax columns in the generated script.
Propiedad públicaMiembro estático NoFileStreamColumn Gets an object that specifies whether to include the FILESTREAM_ON clause when you create VarBinaryMax columns in the generated script.
Propiedad públicaMiembro estático NoIdentities Gets an object value that specifies whether definitions of identity property seed and increment are included in the generated script.
Propiedad públicaMiembro estático NoIndexPartitioningSchemes Gets an object value that specifies whether partition schemes for indexes are included in the generated script.
Propiedad públicaMiembro estático NoMailProfileAccounts Gets an object value that specifies whether mail accounts referenced by mail profiles are included in the generated script.
Propiedad públicaMiembro estático NoMailProfilePrincipals Gets an object value that specifies whether principals referenced by mail profiles are excluded from the generated script.
Propiedad públicaMiembro estático NonClusteredIndexes Gets an object value that specifies whether non-clustered indexes are included in the generated script.
Propiedad públicaMiembro estático NoTablePartitioningSchemes Gets an object value that specifies whether partition schemes for tables are included in the generated script.
Propiedad públicaMiembro estático NoVardecimal Gets the NoVardecimal property value.
Propiedad públicaMiembro estático NoViewColumns Gets an object value that specifies whether to include the specified columns for a view.
Propiedad públicaMiembro estático NoXmlNamespaces Gets an object value that specifies whether XML namespaces are included in the generated script.
Propiedad públicaMiembro estático OptimizerData Gets an object value that specifies whether script optimizer data for the referenced objects are included in the generated script.
Propiedad públicaMiembro estático Permissions Gets an object value that specifies whether to all permissions in the generated script.
Propiedad públicaMiembro estático PrimaryObject Gets an object value that specifies whether the creation of the referenced object is included in the generated script.
Propiedad públicaMiembro estático SchemaQualify Gets an object value that specifies whether the script contains object with no schema.
Propiedad públicaMiembro estático SchemaQualifyForeignKeysReferences Gets an object value that specifies whether tables with no schema that are referenced by a foreign key are included in the generated script.
Propiedad públicaMiembro estático ScriptBatchTerminator Gets the ScriptBatchTerminator property value.
Propiedad públicaMiembro estático ScriptData Gets the ScriptData property value.
Propiedad públicaMiembro estático ScriptDataCompression Gets an object value that specifies whether the creation of the referenced object is included in the generated script.
Propiedad públicaMiembro estático ScriptOwner Gets an object value that specifies whether the creation of the referenced object is included in the generated script.
Propiedad públicaMiembro estático ScriptSchema Gets the ScriptSchema property value.
Propiedad públicaMiembro estático Statistics Gets an object value that specifies whether statistics are generated for any table or view included in the generated script.
Propiedad públicaMiembro estático TimestampToBinary Gets an object value that specifies whether to convert timestamp data types to a binary(8) data types when scripting the creation of a table or user defined data type.
Propiedad públicaMiembro estático ToFileOnly Gets an object value that specifies whether to output to file only or to generate string output too.
Propiedad públicaMiembro estático Triggers Gets an object value that specifies whether to include the definition for triggers in the generated script.
Propiedad públicaMiembro estático WithDependencies Gets an object value that specifies whether to include all dependent objects in the generated script.
Propiedad públicaMiembro estático XmlIndexes Gets an object value that specifies whether XML indexes are included in the generated script.

Principio

  • Last updated on