Interested to Buy Any Domain ? << Click Here >> for more details...
What command do we use to rename a db?
- 5 Answers
- 13722 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 are group functions in query statements in ms sql server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What are the disadvantages of primary key and foreign key in SQL?
Do you know hot add cpu in sql server 2008?
I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,
what are the new features of sql server 2005?
8 Answers HP, Keane India Ltd,
How do I start sql server?
How would you add a section to a table?
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.
Tell me what is the stuff and how does it differ from the replace function?
What are different types of collation sensitivity?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
-
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)
