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
What are subqueries in sql server? Explain its properties.
Explain the different types of joins?
Explain go command in sql server?
What is normalization of database?
What is a filestream?
How to specify the collation for a character data type in ms sql server?
What are character string data types in ms sql server?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What is field with example?
What is the use of floor function in sql server?
Explain the categories of stored procedure?
How to use column default values in insert statements in ms sql server?
What’s the use of custom fields in report?
What are the different types of collation sensitivity?
How to download and install the scaled-down database adventureworkslt?
