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 unique and xaml nonclustered index
How to invoke a trigger on demand?
What are types of subqueries?
Explain how to send email from sql database?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Explain cursor as data base object?
Does index speed up select statements?
What the difference between UNION and UNIONALL?
What is normalization? What number of normalization shapes are there?
What is attribute hierarchy? : sql server analysis services, ssas
What is the minimum recommended amount of ram for sql server 2012 enterprise?
Explain what role entity and relationship play in an ER diagram.
What is difference between equi join and natural join?
Can we use where clause in union?
What is the Main Difference between ACCESS and SQL SERVER?