List all the Database, Table, Columns name in Sql Server

Sql Server 2005

• List All Database name from Sql Server

               Select name from Sys.databases;

• List All Tables from Database 

       use Sample select name from Sys.tables; --> Sample is Database Name
                  

• List All Column names from table

       use Sample select column_name, data_type from information_schema.columns   where table_name= 'Department'; --> Sample is Database Name and Department is Table Name

  Thanks for Reading this article