What command do we use to rename a db, a table and a column?

Posted by Virendradugar on 9/9/2009 | Category: Sql Server Interview questions | Views: 6670

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

To rename db
sp_renamedb ‘oldname’ , ‘newname’

To rename Table
SP_RENAME ‘oldTableName’, ‘NewTableName’

To rename Column
sp_RENAME ‘Table_First.Name’, ‘NameChange’ , ‘COLUMN’

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How many classes can a single .NET DLL contain?

Next > : What is a table called, if it has no Cluster Index ...

Comments or Responses

More Interview Questions by Virendradugar

What is a table called, if it has no Cluster Index?
How to get @@ERROR and @@ROWCOUNT at the same time?
What is the difference between a Local and a Global temporary table?
What is Row_Number()?
Suppose Page_load event is defined in aspx page and same page_load eve ...
Is it possible to create Cluster Index on Unique Key Column?
Can we declare private class in a Namespace?
What is a private constructor? Where will you use it?

Latest Interview Questions

________is one of the new feature added in C# 4.0 ?
How can we access COM object in C#4.0?
________ is new type introduced in C#4.0?
Which is the base class for TypedDataset
Which of the following class does not belong to Collection namespace ?
Which property of textbox cannot be change at run time?
What is the name of base class for .NET
Is it Possible to create more than one machine config file.
More ...