on 2012 Mar 02 7:07 AM
HI,
SELECT table_name=sysobjects.name, column_name=syscolumns.name FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id inner join systypes on syscolumns.type=systypes.type where sysobjects.type='U' order by sysobjects.name,syscolumns.colid
which will give the below result.
Table_name column_name
A xxx
A xyz
………………
I need
Database_name table_name column_name
Request clarification before answering.
FWIW, with MS SQL Server, the following adds the name of the current database:
SELECT database_name = DB_NAME(), table_name=sysobjects.name, column_name=syscolumns.name FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id inner join systypes on syscolumns.type=systypes.type WHERE sysobjects.type='U' ORDER BY sysobjects.name,syscolumns.colid
If you want to access different databases as well, I guess you will have to run the query on the master database and use sysdatabases (possibly in a join with the query above) to list those.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
30 | |
10 | |
8 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.