- --获取所有数据库名
- Select Name FROM Master..SysDatabases order by Name
- --获取所有表名
- Select Name FROM SysObjects Where XType='U' ORDER BY Name
- --获取某个表的全部字段名
- Select Name FROM SysColumns Where id=Object_Id('TableName')
- --获取某个表的全部字段名,字段的类型,字段是否为空,字段的长度
- SELECT syscolumns.name,systypes.name,syscolumns.isnullable,syscolumns.length FROM syscolumns, systypes WHERE syscolumns.xusertype = systypes.xusertype AND syscolumns.id = object_id('tableName')
- --该片段来自于http://www.codesnippet.cn/detail/190420132883.html
来源: http://www.codesnippet.cn/detail/190420132883.html