Showing posts with label Rename table column name in sql server. Show all posts
Showing posts with label Rename table column name in sql server. Show all posts

Monday, 3 February 2014

Sql server change column data types and rename column

I have used below statement successful for rename column and change column data type in sql server

Its working

EXEC  sp_rename 'PurchaseOrder.bisOrderNow' , 'vcOrdeNow'

ALTE TABLE PurchaseOrder ALTER  COLUMN  vcOrdeNow VARCHAR(60)

"PurchaseOrder" is Table name.