insert into T1 values(default,3);
--- 1 row(s) inserted.
select * from T1;
SURROGATE_KEY B
-------------------------------- ----
99 1
100 2
102 3
Example of ALTER TABLE
• This example adds a column:
ALTER TABLE persnl.project
ADD COLUMN projlead
NUMERIC (4) UNSIGNED
52 SQL Statements
