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
Listing a Table’s Structure
USE yourDBName
GO
sp_help yourTableName
GO
Listing All Stored Procs for a Given Database
USE yourDBName
SELECT * FROM sysobjects WHERE type=’p’
GO
SELECT * FROM sysobjects WHERE type=’p’
GO
