Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

Informix CREATEs

 --CREATE TABLE and DROP TABLE commands drop table authors; create table authors (au_id char(11) not null, au_lname varchar(40) not null, au_fname varchar(20) not null, phone char(12), address varchar(40), city varchar(20), state char(2) , zip char(5) ); grant select on authors to public ; drop table publishers; create table publishers ( pub_id char(4) not null, pub_name varchar(40) , address varchar(40) , city varchar(20) , state char(2) ); grant select on publishers to public ; drop table titleauthors; create table titleauthors (au_id char(11) not null, title_id char(6) not null, au_ord smallint , royaltyshare decimal ); grant select on titleauthors to public ; drop table roysched; create table roysched (title_id char(6) not ...