Interested to Buy Any Domain ? << Click Here >> for more details...
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
Define clusters?
How to create function with parameter in sql server?
How raid can influence database performance?
What is Extended user-defined?
What is join query?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is data compression? : sql server database administration
What is the difference between dbcc indexdefrag and dbcc reindex?
what is the difference between Tabular and Matrix report?
How can we solve concurrency problems?
What is a user-defined function in the sql server and what is its advantage?
Which tcp/ip port does the sql server run on? How can it be changed?
How do I shrink an ldf file?
What number sorts of privileges are accessible in sql?
Why should one not prefix user stored procedures with ‘sp_’?
