SQL Alter Table
Using this query you can add , modify or delete columns in a existing table . It is also used to change the table name .
Syntax ->
Alter table table_Name Add column_Name column_Definition ;
If you want to add multiple column in table then you can also do
Alter table table_Name Add ( column_1 column_Definition , column_2 column_Definition ..........column_N column_Definition ) ;
To modify the current column
Alter table table_Name Modify column_Name column_Type ;
To Rename the Table name
Rename column old_Name to New_Name ;
0 Comment(s)