search

Home >Database >Mysql Tutorial > Sqlserver列出所有数据库名,表名,字段名【转】

Sqlserver列出所有数据库名,表名,字段名【转】

WBOY
WBOYOriginal
2016-06-07 17:38:081054browse

1.获取所有数据库名: SELECT Name FROM Master..SysDatabases ORDER BY Name 注意： 表Master与SysDatabases之间有两个点 2.获取所有表名: SELECT Name FROM DatabaseName..SysObjects Where XType='U' ORDER BY Name XType='U':表示所有用户表; XType='S':

1.获取所有数据库名:

SELECT Name FROM Master..SysDatabases ORDER BY Name

注意： 表Master与SysDatabases之间有两个点

2.获取所有表名:

SELECT Name FROM DatabaseName..SysObjects Where XType='U' ORDER BY Name

XType='U':表示所有用户表;

XType='S':表示所有系统表;

3.获取所有字段名:

SELECT Name FROM SysColumns WHERE 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： MongoDB实战（2）工具集与特殊魔术方法Next article： Oracle number date varchar2字段类型占用空间大小

Related articles

See more