This blog is to learn and share SQL DBA and Azure SQL knowledge among people by Bandaru Ajeyudu
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
DB_ID(
);
No comments:
Post a Comment