SQL RENAME DatabaseSometimes you ne

SQL RENAME Database

Sometimes you need to change the name of your databasebecause of the original name was not more relevant to the data. Or, you just want to give a temporary name to that data.

SQL RENAME DATABASE statement is used to change the name of a database.

Let's see how to rename MySql and SQL Server databases.

Rename MySQL database

To rename the mysql database, you need to follow the following syntax:

RENAME DATABASE old_db_name TO new_db_name;
Rename SQL server database using T-SQL

This command is useful for SQL server 2005, 2008, 2008R2 and 2012.

ALTER DATABASE old_name MODIFY NAME = new_name
If you are using SQL server 2000, you can also use this command to rename the database. But, Microsoft phased out it.

EXEC sp_renamedb 'old_name' , 'new_name'

Kết quả (Ireland) 1:

Bunachar Athainmnigh SQL Uaireanta is gá duit a athrú nach raibh an t-ainm do databasebecause ar an t-ainm bunaidh níos ábhartha do na sonraí. Nó, ba mhaith leat ach a thabhairt ar an t-ainm go sealadach leis na sonraí. ráiteas BUNACHAR SONRAÍ SQL athainmniú úsáidtear a athrú ar an ainm an bunachar sonraí. A ligean ar a fheiceáil conas a athainmniú MySQL agus SQL Server bunachar sonraí. Athainmnigh an mbunachar sonraí MySQL a athainmniú ar an mbunachar sonraí MySQL, is gá duit chun leanúint leis an error seo a leanas: BUNACHAR SONRAÍ old_db_name LE new_db_name Athainmnigh = mbunachar freastalaí SQL Athainmnigh ag baint úsáide as T-SQL Tá an ordú úsáideach le haghaidh SQL freastalaí 2005, 2008, 2008R2 agus 2012. old_name ALTER BUNACHAR SONRAÍ MHODHNÚ AINM = new_name Má tá tú ag baint úsáide as SQL freastalaí 2000, is féidir leat é a úsáid freisin seo ordú a athainmniú an mbunachar sonraí. Ach, de réir a chéile Microsoft amach é. sp_renamedb exec 'old_name', 'new_name'