Answer Posted / mohan
Rename a table
This example renames the customers table to custs.
EXEC sp_rename 'customers', 'custs'
B. Rename a column
This example renames the contact title column in the
customers table to title.
EXEC sp_rename 'customers.contacttitle', 'title', 'COLUMN'
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Write a SQL query in order to merge two different columns into single column?
What is named calculation? : sql server analysis services, ssas
Tell me what is normalization? Explain different forms of normalization?
Tell me the phases a transaction has to undergo?
Explain syntax for viewing trigger?
How is a full-text index updated?
What is subquery explain with example?
Where do we use trace frag?
What is a fill factor?
How to specify the collation for a character data type in ms sql server?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What are the disadvantages of indexes?
what is the maximum size of a row? : Sql server database administration
How can you stop stored procedures from recompiling?
What are the steps you will take to improve the performance of a poor performing query?
