: Modify Table Structure
The change in the structure of the tables using ALTER to:
- Add new columns to tables.
- Modify the width of the column.
- Modify the data type of the column (in this case the column must have data).
- Change the length of a column.
EXAMPLE 1: ALTER TABLE Customers
ADD (integer balance, branch char)
In the previous example we add to the Customers table column Balance integer and column type Branch character.
EXAMPLE 2: ALTER TABLE Customers
MODIFY (name char (50));
In the previous example modify the length of the field Name of the Customers table that was kind of character that was char (40) to char (50)
0 comments:
Post a Comment