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
Can we create clustered index on composite key?
How to remove duplicate rows from table except one?
Explain the database you used in your final year project?
What is the difference between having clause and where clause in sql server?
Mention the 3 ways to get a count of the number of records in a table.
what are cursors? : Sql server database administration
What are the key configuration files for sql server reporting services ?
Explain primary key, foreign key and unique key?
What is tempdb in sql server?
Explain how does the report manager work in ssrs?
What is update locks?
What is t-sql script to take database offline – take database online.
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Describe different Processing Modes offered by SSRS?
What is abstracting periodical?
