Interested to Buy Any Domain ? << Click Here >> for more details...
What command do we use to rename a db?
- 5 Answers
- 13946 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / visala
sp_renamedb 'oldname','newname'
alter database <databasename>
modify name=<newdatabasename>
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / swetha
sp_renamedb ?oldname? , ?newname?
alter database ?databasename?
modify name = ?newdatabasename?
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / karthick.r
sp_rename olddatabasename newdatabasename
for eg
sp_rename prodetails empdetails;
in this eg the name of the prodetails is changed into
empdetails using above command
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / babuli
To rename a SQL database follow the these seps:
1. Alter database to single user mode. So that all the
active connection will be terminated. (Database properties
-> options > single usermode)
2. Then rename the database using sp_renamedb oldname, newname
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the dbcc command and why is it used?
Explain what is use of dbcc commands?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is user-defined multi-statement table-valued function?
Explain the basic concepts of SQL server architecture?
2 Answers College School Exams Tests,
How to start and end transact-sql statements?
Tell me about builtinadministrator?
what's the difference between delete table and truncate table commands? : Sql server database administration
Where sql server user names and passwords are stored in sql server? : sql server database administration
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
how to select a field with firstletter as capital and remaining are small letters
How many instances per computer are there in sql server 2000?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
