Please send your Questions & Answers or Feedback to ""

Explain ALTER TABLE statement in SQL ?

The ALTER TABLE statement enables the database to change the structure of a table after it has been created. It is possible to modify the structure of a table even if rows have already been inserted into this table. The ALTER TABLE command can do the below things:

Add a column to an existing table

Modify a column that already exists



ALTER TABLE table_name <ADD column_name data_type |

   MODIFY column_name data_type>

Related Posts Plugin for WordPress, Blogger...
Flag Counter