Show Database ID in SQL Server

 The query below can retrieve database id by supplying the database name

-- Show database id using system view
 SELECT database_id FROM sys.databases
 WHERE name = '<db_name>';

-- Show database id using function
SELECT DB_ID('<db_name>');



No comments:

Post a Comment