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
How much memory that we are using in Logshipping Concept?
What is the exact numeric data type in sql?
Can sql server be linked with other servers like oracle?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
Do you know what is bit data type and whats the information that can be stored inside a bit column?
How to convert a table data in XML format in sql server?
What is a virtual table in sql?
What do you know about system database? : SQL Server Architecture
How to get the definition of a stored procedure back?
Explain the use of containers in ssis?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
Explain triggers?
Does a server store data?
What is the use of partition by in sql server?
What are information schema views?