Handy tips for SQL Server


Handy tips for SQL Server


Returns  DB name & DB ID 

SELECT name as Database_Name, database_id as Database_ID
FROM 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