person.sql

来自「Java the UML Way 书中所有源码」· SQL 代码 · 共 13 行

drop table person;

create table person(
 identNo    integer primary key, 
 firstName  varchar(30) not null,
 lastName   varchar(30) not null);

insert into person values (100, 'EDWARD', 'BROWN');
insert into person values (101, 'ANN MARGARET', 'GREEN');
insert into person values (102, 'JOHN', 'JOHNSON');

commit;