1、提取的数据库结构
Con.ConnectionString = "Driver={sql server};server=192.168.1.112;uid=sa;pwd=;database=db_2008"
Con.Open
Set Rs = Con.OpenSchema(20)
Set MS1.DataSource = Rs
2、提取表结构
rs.fields(i).name
rs.fields(i).type
1、提取的数据库结构
Con.ConnectionString = "Driver={sql server};server=192.168.1.112;uid=sa;pwd=;database=db_2008"
Con.Open
Set Rs = Con.OpenSchema(20)
Set MS1.DataSource = Rs
2、提取表结构
rs.fields(i).name
rs.fields(i).type