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
can an order by clause be used in a creation of a view?
What is the recursive stored procedure in sql server?
Explain indexes disadvantages?
Can you explain powershell included in sql server 2008?
What is exporting utility?
How do you create type- insensitive operator?
What are extended events in sql server?
Explain following error properties?
What is de-normalization and what are some of the examples of it?
Differentiate between a primary key and a unique key.
If a stored procedure is taking a table data type, how it looks?
How to use subqueries with the in operators in ms sql server?
What is the impact on other user sessions when creating indexes?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How to use values from other tables in update statements in ms sql server?
