Handy tips for SQL Server
Returns DB name & DB ID
SELECT name as Database_Name, database_id as Database_IDFROM sys.databases;
Returns servername, DB name, table name, number of rows in
SELECT @@SERVERNAME as ServerName,DB_NAME() AS DbName, s.name AS SchemaName, t.name AS TableName, p.rows AS RowsCount
FROM sys.tables t INNER JOIN sys.schemas s ON t.schema_id=s.schema_id INNER JOIN sys.partitions p ON p.OBJECT_ID = t.OBJECT_ID
No comments:
Post a Comment