Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is truncate table?
Can we perform backup restore operation on tempdb? : sql server database administration
how to create a scrollable cursor with the scroll option? : Sql server database administration
Explain about protocol layer present in SQL server?
How to turn on the mssql api module in php?
What are the types of indexing?
What is analysis service repository?
Explain subquery and state its properties?
what is the difference between count(*) and count(1) ?
Why do we use functions?
What are the two modes of authentication in sql server?
How real and float literal values are rounded?
What is difference between count (*) and count 1?
What is a transact-sql statement?
What is normalization? What number of normalization shapes are there?
