Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What command do we use to rename a db, a table and a column?
on 9/9/2009 | Category:
Sql Server Interview questions
| Views: 4562
To rename db
sp_renamedb ‘oldname’ , ‘newname’
To rename Table
SP_RENAME ‘oldTableName’, ‘NewTableName’
To rename Column
sp_RENAME ‘Table_First.Name’, ‘NameChange’ , ‘COLUMN’
Many Interviews |
< 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
Login to post response
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.