Re: RPT/DCL com file

In article <9232@emory.mathcs.emory.edu> dave.snyder@snide.com (Dave Snyder) writes: > Quoting FreeBird... > > > > when creating a table how do you specify the primary key? > > > When creating a table with Informix products (except the low-level C-ISAM), > there is really no such thing as a primary key. As a matter-of-fact, when > using Informix-SE which uses C-ISAM, if a table is created with one or > more indexes... ALL the indexes are treated as secondary keys. Well, actually, if you are using an Informix SQL engine release 5.0, you specify the primary key in your CREATE TABLE statement: CREATE TABLE customer ( customer_num SERIAL PRIMARY KEY ... When the primary key is a composite key, you can specify PRIMARY KEY (...list of columns...) after declaring the columns.