Home >Database >Mysql Tutorial >SQL Server获取所有数据库名、表名以及字段名
SQL Server获取所有数据库名、表名以及字段名
- WBOYOriginal
- 2016-06-07 14:56:35810browse
SQL Server获取所有数据库名、表名以及字段名 无 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,s
SQL Server获取所有数据库名、表名以及字段名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')
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：配置和使用SQL mailNext article：查找替换表中TEXT字段类型数据