I thought I would list a few queries here that would help you get to know an unfamiliar SQL Server instance and its databases. Listing All Databases for a SQL Server Instance USE Master GO SELECT * FROM sys.Databases GO Listing all Tables for a Given Database USE yourDBName GO SELECT * FROM sys.tables GO [...]