create table state
        (
        code                    char(2),
        sname                   char(15),
        primary key (code)       
        );