Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vishal
Rename a table using sp_rename
sp_rename <Old Table Name>, <New Column Name>
Rename a column using sp_rename
here as third argument we have to provide column. default
third argument for sp_rename is table.
sp_rename <table name>.<old Column Name>, <New Column Name>,
'column'
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Define candidate key, alternate key, and composite key.
Define synonym?
What is normalization? Explain its different types?
How to make remote connection in database?
How many clustered indexes there can be on table ?
How real and float literal values are rounded?
What is sql server query analyzer?
What do you mean by an execution plan?
How do you rebuild an identity column?
Explain how you can configure a running aggregate in SSRS?
How to list all tables in the database using odbc_tables()?
How to recompile stored procedure at run time?
how we use window authentication connection with sql server.?
What is the definition for sql server 2000?
Explain what is the difference between union and union all?
