Alter Syntax is SQL programming language is used to express some command to exchange the table features such as column and data types in Microsoft Access or SQL Server Database:
Alter Table Table Name Alter Column data type
Alter Table Table Name Drop Column
Alter Table Table Name Add Column...
Example Code To Add New Column:
Alter Table Tbl_Customer add Personal_Contact varchar;
Example Code to Add Relationship between Table and Table
alter table Tbl_Staff add foreign key(Dept_ID) references Tbl_Depart(Dept_ID);