how to add new columns in already created table ???

Question

i was unable to search how to create new column in already created table.

Answer 1

ALTER TABLE table_name
ADD column_name datatype

E.g Alter Table Employee Add Mail_Id varchar(100)

Answer 2

You must use the ALTER TABLE statement, I let you check the specific syntax by yourself (as it depends on the SQL library that you use).

Answer 3

thanks bro. really helpfull