Latest news
Home » SQL » How to ALTER table in SQL

How to ALTER table in SQL

ALTER a table in SQL

Use the following commands for add,change,drop table fields in SQL.
SQL>AlTER TABLE <Table name> <ADD,DROP,CHANGE> <field name>
ALTER TABLE  `test` ADD  `test INT NOT NULL
ALTER TABLE  `test` DROP `name`
ALTER TABLE  `test` CHANGE  `name`  `student_name` INT( 11 ) NOT NULL

Leave a Reply

x

Check Also

How can be list the installed SQL Server instances

Press window+R windows run window will open and then type cmd Command prompt will open ...