Condividi tramite

  • Articolo

Classe ScriptingOptions

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

Spazio dei nomi:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public NotInheritable Class ScriptingOptions
'Utilizzo
Dim instance As ScriptingOptions

public sealed class ScriptingOptions

public ref class ScriptingOptions sealed

[<SealedAttribute>]
type ScriptingOptions =  class end

public final class ScriptingOptions

Osservazioni

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

Thread Safety

Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.

Esempi

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")
'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

Gerarchia di ereditarietà

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

Thread Safety

Tutti i membri pubblici static (Shared in Visual Basic) di questo tipo sono thread safe. I membri di istanza non hanno garanzia di essere thread safe.