ALTER TABLE table_name RENAME COLUMN old_name to new_name;
ALTER TABLE table_name RENAME COLUMN BookingRefNo to RefNo;
EXEC sp_rename 'TableName.BookingRefNo ', 'RefNo ', 'COLUMN' GO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)