SQLDMO由Microsoft SQL Server自带的SQLDMO.dll提供,由于SQLDMO.dll是一个COM对象,所以大家在用之前必须在.NET项目中添加对它的引用。
SQLDMO.SQLServer oServer
=
new
SQLDMO.SQLServer();
oServer.Connect( "127.0.0.1 " , " sa " , "sa password " );
SQLDMO._Database mydb = oServer.Databases.Item( " northwind " , " owner " );
SQLDMO._Table myTable = mydb.Tables.Item("Categories", " dbo " );
string s = myTable.Script(SQLDMO.SQLDMO_SCRIPT_TYPE.SQLDMOScript_Default, null , null , SQLDMO.SQLDMO_SCRIPT2_TYPE.SQLDMOScript2_Default);
oServer.DisConnect();
Source.Text = s;
oServer.Connect( "127.0.0.1 " , " sa " , "sa password " );
SQLDMO._Database mydb = oServer.Databases.Item( " northwind " , " owner " );
SQLDMO._Table myTable = mydb.Tables.Item("Categories", " dbo " );
string s = myTable.Script(SQLDMO.SQLDMO_SCRIPT_TYPE.SQLDMOScript_Default, null , null , SQLDMO.SQLDMO_SCRIPT2_TYPE.SQLDMOScript2_Default);
oServer.DisConnect();
Source.Text = s;