alter table column name in sql code example

Example 1: sql add column

ALTER TABLE Customers
ADD Email varchar(255);

Example 2: sql alter column size

ALTER TABLE table_name
ALTER COLUMN column_name datatype;

Example 3: alter table name sql

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