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 [...]
Posts Tagged ‘SQLSERVER’
Useful SQL Server Queries for Getting to Know a Database
Posted in SQL Server Queries, tagged Listing all stored procedures, SQL Server Discover Databases, SQLSERVER, SQLSERVER Queries on September 16, 2008 | Leave a Comment »
-
Recent Comments
