Tag: alter table


Alter query is user to change the structure of a database table if it has been created and though it has some data .The alter table gives us the facility to delete,add,rename columns and create/destroy indexes as well as change the data type of already existing table. Adding Column with ALTER TABLE STATEMENT The syntax to alter table is :ALTER TABLE tablename ADD COLUMN colname coltype; T