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
Why use cursor in sql server?
What is difference statement and preparedstatement?
What is a cache in ssrs?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
what's new in sql server 2016?
What is the difference between a stored procedure and a user defined function?
What is the use of @@spid?
What stored by the model? : sql server database administration
What have included columns when we talk about sql server indexing?
What is the fastest way to permanently delete a 1 million row table named customers?
What are the mathematical functions supported by sql server 2005?
What is sql server used for?
what is raid and what are different types of raid configurations? : Sql server database administration
What's the information that can be stored inside a bit column?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
