{"id":107,"date":"2018-12-05T16:44:26","date_gmt":"2018-12-05T16:44:26","guid":{"rendered":"https:\/\/barkhane.com\/sql\/2018\/12\/05\/sql-rename-database\/"},"modified":"2024-03-03T18:04:23","modified_gmt":"2024-03-03T18:04:23","slug":"sql-rename-database","status":"publish","type":"post","link":"https:\/\/barkhane.com\/sql\/sql-rename-database\/","title":{"rendered":"SQL RENAME Database"},"content":{"rendered":"

SQL RENAME DATABASE is used when you need to change the name of your database. Sometimes it is used because you think that the original name is not more relevant to the database or you want to give a temporary name to that database<\/a>.<\/p>\n

\n

Let\\’s see how to rename MySql and SQL Server databases.<\/p>\n

Rename MySQL database<\/h4>\n

To rename the mysql database, you need to follow the following syntax:<\/p>\n

\n
\n
\n
<\/div>\n<\/div>\n
    \n
  • RENAME\u00a0DATABASE<\/span>\u00a0old_db_name\u00a0TO<\/span>\u00a0new_db_name;<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
    \n

    Rename SQL server database using T-SQL<\/h4>\n

    This command is useful for SQL server 2005, 2008, 2008R2 and 2012.<\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n
      \n
    • ALTER<\/span>\u00a0DATABASE<\/span>\u00a0old_name\u00a0MODIFY<\/span>\u00a0NAME<\/span>\u00a0=\u00a0new_name<\/li>\n<\/ul>\n<\/div>\n<\/div>\n

      If you are using SQL server 2000, you can also use this command to rename the database. But, Microsoft phased out it.<\/p>\n

      \n
      \n
      \n
      <\/div>\n<\/div>\n
        \n
      • EXEC<\/span>\u00a0sp_renamedb\u00a0\\’old_name\\’<\/span>\u00a0,\u00a0\\’new_name\\’<\/span><\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

        SQL RENAME DATABASE is used when you need to change the name of your database. Sometimes it is used because […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2],"tags":[],"class_list":["post-107","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts\/107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/comments?post=107"}],"version-history":[{"count":0,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts\/107\/revisions"}],"wp:attachment":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/media?parent=107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/categories?post=107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/tags?post=107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}