Find all Database in sql server 2005

select * from sys.databases


select * from sys.tables



To see all the column of table



select * from sys.all_columns where [object_id]= OBJECT_ID (N'dbo.emp')//Emp is table name