Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to rename the table

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


Please Help Members By Posting Answers For Below Questions

How to backup SQL Server Reporting Services ?

148


What is difference between global temporary tables and local temporary tables?

1211


What are the different types of subquery?

1134


Do you think BCNF is better than 2NF & 3NF? Why?

1256


How do I find query history in sql server?

925


What are temporal tables in sql server 2016?

868


Why it is recommended to avoid referencing a floating point column in the where clause?

949


What is unique key constraint?

1030


What is replication with database mirroring? : sql server database administration

1052


Explain features of analysis services?

978


Can a unique index be created on a column, which contains null?

906


Difference between Inner vs outer joins?

929


Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1034


Mention the command used to rename the database.

983


How to create function with parameter in sql server?

1088