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
How retrieve field names from the table in SQL through JAVA code?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What is primary key and example?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
How to retrieve error messages using mssql_get_last_message()?
what is the difference between delete table and truncate table commands? : Sql server database administration
What are the essential components of sql server service broker?
How many columns can we include on clustered index ?
How to make a remote connection in a database?
What is CTE in SQL
What is reference section?
Where the sql logs gets stored?
How to handle error or exception in sql?
Tell me what is difference between clustered and non clustered index?
How to get the definition of a user defined function back?
