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.
Its working
EXEC sp_rename 'PurchaseOrder.bisOrderNow' , 'vcOrdeNow'
ALTE TABLE PurchaseOrder ALTER COLUMN vcOrdeNow VARCHAR(60)
"PurchaseOrder" is Table name.
No comments:
Post a Comment