• June 13, 2021

PHSARIT

Bring Technology Ideas with you

 Alter Syntax in SQL programming

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);

Try yourself!

Related post