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
How to use "begin ... End" statement structures in ms sql server?
Is it safe to delete log files?
What are the advantages of using stored procedures in sql server?
How to create a simple table to test triggers in ms sql server?
What are the five major components of a dbms?
Can you use order by when defining a view?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is failover clustering overview?
How can you set the threshold at which sql server will generate keysets asynchronously?
How to use go command in "sqlcmd"?
What is lookup override?
What is multilevel indexing?
how can you attach more than 20 ldf files in sql server
How do I open a .db file?
Can we use where and having clause together?
