共用方式為


Script 方法 (SqlSmoObject[])

Generates Transact-SQL scripts that can be used to re-create a list of objects.

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

語法

'宣告
Public Function Script ( _
    objects As SqlSmoObject() _
) As StringCollection
'用途
Dim instance As Scripter
Dim objects As SqlSmoObject()
Dim returnValue As StringCollection

returnValue = instance.Script(objects)
public StringCollection Script(
    SqlSmoObject[] objects
)
public:
StringCollection^ Script(
    array<SqlSmoObject^>^ objects
)
member Script : 
        objects:SqlSmoObject[] -> StringCollection 
public function Script(
    objects : SqlSmoObject[]
) : StringCollection

參數

傳回值

型別:System.Collections.Specialized. . :: . .StringCollection
A StringCollection object value that specifies the Transact-SQL scripts for the list of objects.

備註

This method throws an exception if it is invoked when the ScriptData property is 0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAAAQAAAAAAAAAA EAAAAgAAAAEAAAD+////AAAAAAAAAAD///////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////9 /////v////7////+//////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////1IA bwBvAHQAIABFAG4AdAByAHkAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAWAAUA//////////8BAAAA4IHR3y9ezhGkSQCqAEqAPQAAAAAAAAAAAAAAACAnmLLCF8kB AwAAAMAAAAAAAAAAYwBvAG4AdABlAG4AdABzAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAABIAAgECAAAA//////////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAABAEMAbwBtAHAATwBiAGoAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEgACAP///////////////wAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAB4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////// ////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA/v// /wIAAAD+//////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////8AAgwA CAAAAMIBAADKCAAAAAAAAAAA/////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIAcoAA8CCEAAAB/ 1AgAAQD+/wMKAAD/////4IHR3y9ezhGkSQCqAEqAPR4AAABNaWNyb3NvZnQgRm9ybXMgMi4wIFNj cm9sbEJhcgAQAAAARW1iZWRkZWQgT2JqZWN0ABIAAABGb3Jtcy5TY3JvbGxCYXIuMQD0ObJxAAAA AAAAAAAAAAAAAAD/AAAAAAAAAP8AAAAAAABwHKAdAAAAAAAAAAAAAAAAAAAAAAAAAAAA/P4AADwA AAA8APsA9COgAACAAAAUAAAAAAAAAAAAAAAAAAAAAAAA/2QAAAAABAAEAAQAAAAAAAAAAAAAAAAA /wAAAP8AAAD/AAAAAAD/AAAAAAAAAAAAAAAAAAAAAAAAFAAUAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP// //8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD0I6AACgAAAAAAAAAAAAAABQAAAAAACgAFAA== set to True. This prevents the entire dataset from being scripted to a StringCollection object.

範例

指令碼