用实SQL语句
1.获取所有
数据库名: www.2cto.com
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