Méthode StoredProcedure.Script (ScriptingOptions)
Generates a Transact-SQL script that can be used to re-create the stored procedure as specified by the script options.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Function Script ( _
scriptingOptions As ScriptingOptions _
) As StringCollection
'Utilisation
Dim instance As StoredProcedure
Dim scriptingOptions As ScriptingOptions
Dim returnValue As StringCollection
returnValue = instance.Script(scriptingOptions)
public StringCollection Script(
ScriptingOptions scriptingOptions
)
public:
virtual StringCollection^ Script(
ScriptingOptions^ scriptingOptions
) sealed
abstract Script :
scriptingOptions:ScriptingOptions -> StringCollection
override Script :
scriptingOptions:ScriptingOptions -> StringCollection
public final function Script(
scriptingOptions : ScriptingOptions
) : StringCollection
Paramètres
- scriptingOptions
Type : Microsoft.SqlServer.Management.Smo.ScriptingOptions
A ScriptingOptions object value that is used to specify the script options.
Valeur de retour
Type : System.Collections.Specialized.StringCollection
A StringCollection system object value that contains a list of Transact-SQL statements in the script.
Implémente
IScriptable.Script(ScriptingOptions)
Notes
[!REMARQUE]
Le script généré contient peut-être des procédures internes non documentées, qui sont nécessaires pour la sortie complète du script.
Exemples
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Smo