alter field name in sql code example

Example 1: alter table name sql

-- Microsoft SQL style
EXEC sp_rename 'TableOldName', 'TableNewName';

Example 2: modify column name in tsql

sp_rename 'table_name.old_column', 'new_name', 'COLUMN';