共用方式為


ScriptingOptions 類別

The ScriptingOptions object provides programmatic options to the options that can be set for scripting operations.

繼承階層

System. . :: . .Object
  Microsoft.SqlServer.Management.Smo..::..ScriptingOptions

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public NotInheritable Class ScriptingOptions
'用途
Dim instance As ScriptingOptions
public sealed class ScriptingOptions
public ref class ScriptingOptions sealed
[<SealedAttribute>]
type ScriptingOptions =  class end
public final class ScriptingOptions

ScriptingOptions 型別公開下列成員。

建構函式

  名稱 說明
公用方法 ScriptingOptions() () () () Initializes a new instance of the ScriptingOptions class.
公用方法 ScriptingOptions(ScriptingOptions) Initializes a new instance of the ScriptingOptions class based on the specified scripting options.
公用方法 ScriptingOptions(ScriptOption) Initializes a new instance of the ScriptingOptions class based on the specified ScriptOption object, based on the specified script option.

上層

屬性

  名稱 說明
公用屬性 AgentAlertJob Gets or sets the Boolean property that specifies whether to include SQL Server Agent job name for alert objects in the script.
公用屬性 AgentJobId Gets or sets the Boolean property that specifies whether to include SQL Server Agent job ID values for alert objects in the script.
公用屬性 AgentNotify Gets or sets the Boolean property that specifies whether to include notifications for any SQL Server Agent alerts that are in the script.
公用屬性 AllowSystemObjects Gets or sets the Boolean property that specifies whether system objects can be scripted.
公用屬性 AnsiFile Gets or sets the Boolean property that specifies whether the script uses multibyte characters and requires code page 1252 to evaluate characters' meaning.
公用屬性 AnsiPadding Gets or sets a Boolean property 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.
公用屬性 AppendToFile Gets or sets a Boolean property value that specifies whether the script is appended to the end of the output file or overwrites it.
公用屬性 BatchSize Gets or sets the number of statements after which to script batch terminator.
公用屬性 Bindings Gets or sets a Boolean property value that specifies whether the binding statements sp_binddefault and sp_bindrule are included in the generated script. This property applies only when scripting a SQL Server table.
公用屬性 ChangeTracking Gets or sets the ChangeTracking property value.
公用屬性 ClusteredIndexes Gets or sets a Boolean property value that specifies whether statements that define clustered indexes are included in the generated script.
公用屬性 ContinueScriptingOnError Gets or sets the Boolean property value that specifies whether the scripting operation continues after an error is encountered.
公用屬性 ConvertUserDefinedDataTypesToBaseType Gets or sets the Boolean property value that specifies whether user-defined data types are converted to the most appropriate SQL Server base data types in the generated script.
公用屬性 DdlBodyOnly Gets or sets the Boolean property 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.
公用屬性 DdlHeaderOnly Gets or sets the Boolean property 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.
公用屬性 Default Gets or sets the Boolean property value that specifies whether the creation of the referenced object is included in the generated script.
公用屬性 DriAll Gets or sets the Boolean property value that specifies whether all DRI objects are included in the generated script.
公用屬性 DriAllConstraints Gets or sets the Boolean property value that specifies whether all declarative referential integrity constraints are included in the generated script.
公用屬性 DriAllKeys Gets or sets the Boolean property value that specifies whether the dependency relationships defined by all declarative referential integrity keys are included in the generated script.
公用屬性 DriChecks Gets or sets the Boolean property value that specifies whether column specific dependency relationships as defined in check constraints with enforced declarative referential integrity are included in the script.
公用屬性 DriClustered Gets or sets the Boolean property value that specifies whether dependency relationships defined in clustered indexes with enforced declarative referential integrity are included in the script.
公用屬性 DriDefaults Gets or sets the Boolean property value that specifies whether dependency relationships defined in defaults with enforced declarative referential integrity are included in the script.
公用屬性 DriForeignKeys Gets or sets the Boolean property value that specifies whether dependency relationships defined in foreign keys with enforced declarative referential integrity are included in the script.
公用屬性 DriIncludeSystemNames Gets or sets the Boolean property value that specifies whether the system-generated constraint names that are used to enforce declarative referential integrity are included in the script.
公用屬性 DriIndexes Gets or sets the Boolean property value that specifies whether PRIMARY KEY constraints that use a unique index to implement the declarative referential integrity are included in the script.
公用屬性 DriNonClustered Gets or sets the Boolean property value that specifies whether dependency relationships that are defined in non-clustered indexes that have enforced declarative referential integrity are included in the script.
公用屬性 DriPrimaryKey Gets or sets the Boolean property value that specifies whether dependency relationships that are defined in primary keys which have enforced declarative referential integrity are included in the script.
公用屬性 DriUniqueKeys Gets or sets the Boolean property value that specifies whether dependency relationships that are defined in unique keys which have enforced declarative referential integrity are included in the script.
公用屬性 DriWithNoCheck Gets or sets the Boolean property value that specifies whether the no check statement is included in the script.
公用屬性 Encoding Gets or sets the encoding for the scripting options.
公用屬性 EnforceScriptingOptions Gets or sets the Boolean property value that specifies whether the application of all scripting options is enforced for text-based objects, such as SchemaQualify.
公用屬性 ExtendedProperties Gets or sets the Boolean property value that specifies whether extended object properties are included in the generated script.
公用屬性 FileName Gets or sets the name of the file to which the generated script is output.
公用屬性 FullTextCatalogs Gets or sets the Boolean property value that specifies whether full-text catalogs are included in the generated script.
公用屬性 FullTextIndexes Gets or sets the Boolean property value that specifies whether full-text indexes are included in the generated script.
公用屬性 FullTextStopLists Gets or sets the Boolean property value that specifies whether full-text stop lists are included in the generated script.
公用屬性 IncludeDatabaseContext Gets or sets the Boolean property value that specifies whether database context is included in the generated script.
公用屬性 IncludeDatabaseRoleMemberships Gets or sets the IncludeDatabaseRoleMemberships property value.
公用屬性 IncludeFullTextCatalogRootPath Gets or sets the IncludeFullTextCatalogRootPath property value.
公用屬性 IncludeHeaders Gets or sets a Boolean property value that specifies whether the generated script is prefixed with a header that contains information which includes the date and time of generation.
公用屬性 IncludeIfNotExists Gets or sets a Boolean property value that specifies whether to check the existence of an object before including it in the script.
公用屬性 Indexes Gets or sets the Boolean property value that specifies whether indexes are included in the generated script.
公用屬性 LoginSid Gets or sets the Boolean property value that specifies whether the security identifiers are included for any scripted logins in the generated script.
公用屬性 NoAssemblies Gets or sets the Boolean property value that specifies whether assemblies are included in the generated script.
公用屬性 NoCollation Gets or sets the Boolean property value that specifies whether to include the collation clause in the generated script.
公用屬性 NoCommandTerminator Gets or sets the Boolean property value that specifies whether individual Transact-SQL statements are delimited in the generated script.
公用屬性 NoExecuteAs Gets or sets the Boolean property value that specifies whether the EXECUTE AS options for stored procedures and user-defined functions are included in the script.
公用屬性 NoFileGroup Gets or sets the Boolean property value that specifies whether to include the 'ON <filegroup>' clause in the generated script.
公用屬性 NoFileStream Gets or sets an object that specifies whether to include the FILESTREAM_ON clause when you create VarBinaryMax columns in the generated script.
公用屬性 NoFileStreamColumn Gets or sets an object that specifies whether to include the FILESTREAM_ON clause when you create VarBinaryMax columns in the generated script.
公用屬性 NoIdentities Gets or sets the Boolean property value that specifies whether definitions of identity property seed and increment are included in the generated script.
公用屬性 NoIndexPartitioningSchemes Gets or sets the Boolean property value that specifies whether partition schemes for indexes are included in the generated script.
公用屬性 NoMailProfileAccounts Gets or sets the Boolean property value that specifies whether mail accounts that are referenced by mail profiles are included in the generated script.
公用屬性 NoMailProfilePrincipals Gets or sets the Boolean property value that specifies whether principals that are referenced by mail profiles are included in the generated script.
公用屬性 NonClusteredIndexes Gets or sets the Boolean property value that specifies whether non-clustered indexes are included in the generated script.
公用屬性 NoTablePartitioningSchemes Gets or sets the Boolean property value that specifies whether partition schemes for tables are included in the generated script.
公用屬性 NoVardecimal Gets or sets an object that specifies whether to include the N clause when you create vardecimal columns in the generated script.
公用屬性 NoViewColumns Gets or sets the Boolean property value that specifies whether to include the specified columns for a view.
公用屬性 NoXmlNamespaces Gets or sets the Boolean property value that specifies whether XML namespaces are included in the generated script.
公用屬性 OptimizerData Gets or sets the Boolean property value that specifies whether script optimizer data for the referenced objects are included in the generated script.
公用屬性 Permissions Gets or sets the Boolean property value that specifies whether to include all permissions in the generated script.
公用屬性 PrimaryObject Gets or sets the Boolean property value that specifies whether the creation of the referenced object is included in the generated script.
公用屬性 SchemaQualify Gets or sets the Boolean property value that specifies whether the schemas associated with objects are included in the generated script.
公用屬性 SchemaQualifyForeignKeysReferences Gets or sets the Boolean property value that specifies whether schema-qualified table references for foreign key constraints are included in the generated script.
公用屬性 ScriptBatchTerminator Gets or sets the ScriptBatchTerminator property value.
公用屬性 ScriptData Gets or sets the ScriptData property value.
公用屬性 ScriptDataCompression Gets or sets the Boolean property value that specifies whether to include data compression information in the generated script.
公用屬性 ScriptDrops Gets or sets the Boolean property value that specifies whether the script operation generates a Transact-SQL script to remove the referenced component.
公用屬性 ScriptOwner Gets or sets the Boolean property value that specifies whether the script owner is included in the generated script.
公用屬性 ScriptSchema Gets or set the ScriptSchema property value.
公用屬性 Statistics Gets or sets the Boolean property value that specifies whether to include statistics for any table or view that is included in the generated script.
公用屬性 TargetDatabaseEngineType Gets or sets the DatabaseEngineType property value.
公用屬性 TargetServerVersion Gets or sets the version of the instance of SQL Server for which the generated script is intended.
公用屬性 TimestampToBinary Gets or sets the Boolean property value that specifies whether to convert timestamp data types to binary(8) data types when scripting the creation of a table or user-defined data type.
公用屬性 ToFileOnly Gets or sets the Boolean property value that specifies whether to output to file only or to also generate string output.
公用屬性 Triggers Gets or sets the Boolean property value that specifies whether to include the definition for triggers in the generated script.
公用屬性 WithDependencies Gets or sets the Boolean property value that specifies whether to include all dependent objects in the generated script.
公用屬性 XmlIndexes Gets or sets the Boolean property value that specifies whether XML indexes are included in the generated script.

上層

方法

  名稱 說明
公用方法 Add(ScriptOption) Adds a ScriptOption object to the ScriptingOptions object.
公用方法靜態成員 Add(ScriptingOptions, ScriptOption) Adds the specified ScriptOption and ScriptingOptions objects to the ScriptingOptions.
公用方法靜態成員 ConvertVersion Converts the server version to a SqlServerVersion value.
公用方法 Equals (繼承自 Object。)
受保護的方法 Finalize (繼承自 Object。)
公用方法 GetHashCode (繼承自 Object。)
公用方法 GetType (繼承自 Object。)
受保護的方法 MemberwiseClone (繼承自 Object。)
公用方法 Remove Removes a ScriptOption object from the ScriptingOptions object.
公用方法 SetTargetDatabaseEngineType Sets the database engine type as specified in a DatabaseEngineType object.
公用方法 SetTargetServerVersion Sets the version of the instance of SQL Server on which the scripting operation is run.
公用方法靜態成員 Subtract Subtracts the specified ScriptOption value from the specified ScriptingOptions object.
公用方法 ToString Returns a string that represents the ScriptingOptions object. (覆寫 Object. . :: . .ToString() () () ()。)

上層

運算子

  名稱 說明
公用運算子靜態成員 Addition Creates a set of scripting options by performing an addition operation on a ScriptingOptions object and a ScriptOption object.
公用運算子靜態成員 Subtraction Creates a set of scripting options by performing an subtraction operation on a ScriptingOptions object and a ScriptOption object.

上層

備註

警告注意事項注意

Some scripting options cause the Transfer object to generate script that does not execute on the target server.

Thread Safety

此型別的任何公用靜態 (在 Microsoft Visual Basic 為共用) 成員具備多執行緒作業安全。不保證所有執行個體成員都是安全執行緒。

範例

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'Define a Scripter object and set the required scripting options.
Dim scrp As Scripter
scrp = New Scripter(srv)
scrp.Options.ScriptDrops = False
scrp.Options.WithDependencies = True
'Iterate through the tables in database and script each one. Display the script.
'Note that the StringCollection type needs the System.Collections.Specialized namespace to be included.
Dim tb As Table
Dim smoObjects(1) As Urn
For Each tb In db.Tables
    smoObjects = New Urn(0) {}
    smoObjects(0) = tb.Urn
    If tb.IsSystemObject = False Then
        Dim sc As StringCollection
        sc = scrp.Script(smoObjects)
        Dim st As String
        For Each st In sc
            Console.WriteLine(st)
        Next
    End If
Next

PowerShell

$srv = New-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
$scrp = New-Object Microsoft.SqlServer.Management.Smo.Scripter($srv)
$scrp.Options.ScriptDrops = $FALSE
$scrp.Options.WithDependencies = $TRUE
$tb = New-Object Microsoft.SqlServer.Management.Smo.Table
#$smoObjects = new-object Microsoft.SqlServer.Management.Smo.Urn[]0
$smoObjects = $tb.Urn
foreach ($tb in $db.Tables)
{
   $smoObjects = $tb.Urn
   if ($tb.IsSystemObject -eq $FALSE)
   {
      $sc = $scrp.Script($smoObjects)
      foreach ($st in $sc)
      {
         Write-Host $st
      }
   }
}

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。