![]() ![]() Refresh the database list in Object Explorer. If the database was your default database, see Reset your default database after rename. ![]() In Object Explorer, expand Databases, right-click the database to rename, and then select Rename.Įnter the new database name, and then select OK If you're using SQL Server, you can set the database to single-user mode to close any open connections and prevent other users from connecting while you're changing the database name. ![]() Make sure that there are no open connections to the database. In Object Explorer, connect to an instance of SQL Server, and then expand that instance. Or on the top menu, select View, and then select Object Explorer: In SQL Server Management Studio, select Object Explorer. Use the following steps to rename a SQL Server or Azure SQL database using SQL Server Management Studio. Requires ALTER permission on the database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |