Saturday, 1 June 2019

View a List of Databases on an Instance of SQL Server

Query 1:

SELECT name, database_id, create_date  FROM sys.databases ;

If u need only the User-defined databases;

Query 1: select * from sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb');

Query 2: SELECT name,filename ,sid FROM dbo.sysdatabases  WHERE dbid > 4

No comments:

Post a Comment

SQL Query Table Name with Rows Counts

SELECT     TableName = t.NAME,     TableSchema = s.Name,     RowCounts = p.rows FROM     sys.tables t INNER JOIN     sys.schemas s ...