Friday, September 26, 2008

Best Shaving Cream For Men In India

: 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