代码如下:–设置sql 可以获取实例名称sp_configure ‘xp_cmdshell’ , 1;goreconfigure;go
–获取实例名EXEC sys .xp_cmdshell ‘sqlcmd -Lc’
–获取所有数据库Select * FROM Master..SysDatabases order by Name
–获取数据库所有表use yeekang —数据库名称select * from sysobjects where type = ‘U’ order by name
–获取指定表字段select * from syscolumns where id= OBJECT