Database Reference
In-Depth Information
Figure 20.8
ALTER TABLE
Constraints Syntax.
20.3.2
ALTER VIEW Syntax
As with the CREATE TABLE and CREATE VIEW commands, constraint
syntax for the ALTER VIEW command is similar to that of the ALTER
TABLE command. ALTER VIEW command syntax is shown in Figure
20.9. Once again, please see Chapter 19 for details on working with con-
straints and views.
Figure 20.9
ALTER VIEW
Constraints Syntax.
20.3.3
Working with Constraints and ALTER TABLE
Now let's explain using constraints by using some ALTER TABLE com-
mand examples.
Once you have created a table, you can add new constraints, modify,
and drop existing constraints using the ALTER TABLE command.
