1.获取所有数据库名:
Select Name FROM Master..SysDatabases order by Name
2.获取所有表名:
Select Name FROM SysObjects Where XType='u' orDER BY Name
3.获取所有字段名:
Select Name FROM SysColumns Where id=Object_Id('莪山办公IP')
4、获取表中所有记录
Select * from 莪山办公IP
Select Name FROM Master..SysDatabases order by Name
2.获取所有表名:
Select Name FROM SysObjects Where XType='u' orDER BY Name
3.获取所有字段名:
Select Name FROM SysColumns Where id=Object_Id('莪山办公IP')
4、获取表中所有记录
Select * from 莪山办公IP