{"id":59,"date":"2025-05-22T13:18:27","date_gmt":"2025-05-22T11:18:27","guid":{"rendered":"https:\/\/paessens.org\/blog\/?p=59"},"modified":"2026-01-21T08:43:28","modified_gmt":"2026-01-21T07:43:28","slug":"how-do-i-see-list-of-databases","status":"publish","type":"post","link":"https:\/\/paessens.org\/blog\/index.php\/2025\/05\/22\/how-do-i-see-list-of-databases\/","title":{"rendered":"How do I see list of databases?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The following SQL Query provide list of databases:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>SELECT name, database_id, create_date<br>FROM sys.databases;<br>GO<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">See also the Microsoft documentation for\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/databases\/view-a-list-of-databases-on-an-instance-of-sql-server?view=sql-server-ver17\">View list of databases on SQL Server<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The following SQL Query provide list of databases: SELECT name, database_id, create_dateFROM sys.databases;GO See also the Microsoft documentation for\u00a0View list of databases on SQL Server<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,18],"tags":[19],"class_list":["post-59","post","type-post","status-publish","format-standard","hentry","category-ms-sql","category-mssql_general","tag-ms-sql"],"_links":{"self":[{"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/posts\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":1,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"predecessor-version":[{"id":61,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/posts\/59\/revisions\/61"}],"wp:attachment":[{"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}