记录一下,备用。
1.查询所有库名
Select Name From Master..SysDatabases order By Name
2.查询该库所有的用户表名
Select Name From SysObjects Where XType='U' order By Name
3.查询TABLENAME表所有字段名
Select Name From SysColumns Where id=Object_Id('TABLENAME')
记录一下,备用。
1.查询所有库名
Select Name From Master..SysDatabases order By Name
2.查询该库所有的用户表名
Select Name From SysObjects Where XType='U' order By Name
3.查询TABLENAME表所有字段名
Select Name From SysColumns Where id=Object_Id('TABLENAME')