what is right command for change column name in sql database tableis this writeALTER TABLE tablenameChange column 1 column 2 Data TypeORALTER TABLE Customer CHANGE Address Addr char50why this commands give error continous

Refer the below queryspRENAME 39TableNameOldColumnName39 39NewColumnName39 39COLUMN39ExspRENAME 39CustomersCustomerId39 39CustId39 39COLUMN39

How to (change / modify / alter) column name of table in SQL

AnkitPal

what is right command for change column name in sql database table.

is this write-

ALTER TABLE "table_name" Change "column 1" "column 2" ["Data Type"];

ALTER TABLE Customer CHANGE Address Addr char(50);

why this commands give error, continous.

dharmend...

0 3

Refer the below query.

sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

sp_RENAME 'Customers.[CustomerId]' , 'CustId', 'COLUMN'