T-SQL (2000) List Tables, Columns

• forefj

  Mr or Mrs. 500

  Points: 593

  More actions

  May 15, 2013 at 2:02 pm

  #73375

  In T-SQL (2000), I have a query that lists all Tables and Columns, along with Data Types.

  select *

  from information_schema.columns

  order by table_name, ordinal_position

  However, I have multiple databases on the SQL Server and I don't see which Database the Tables belong too. Any ideas on how I can adjust this to give the database along with the tables. Or a method I can run this against a specific database, rather than all databases. Thanks.

• forefj

  Mr or Mrs. 500

  Points: 593

  More actions

  May 15, 2013 at 2:11 pm

  #1615567

  Found the answer on another site:

  select DB_NAME() as Database_name, * from information_schema.columns