primary key on create table?

Cristian

Delphi Developer

Wed, 24 Mar 2004 14:05:17 GMT

primary key on create table?

This command create a Tz0ID table, but i need put primary key
in field COD? How i make this on this sql command?

Create Table Tz0ID([cod] [float] NOT NULL,
[id] [varchar] (256) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL,
[port] [varchar] (10) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[pass] [varchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[sinfo] [varchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[sbuild] [int] NULL ,
[dtup] [datetime] NOT NULL)

Jim Elde

Delphi Developer

Fri, 26 Mar 2004 20:18:23 GMT

Re:primary key on create table?

Christian,

Does

Create Table Tz0ID([cod] [float] NOT NULL,
[id] [varchar] (256) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL,
[port] [varchar] (10) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[pass] [varchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[sinfo] [varchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[sbuild] [int] NULL ,
[dtup] [datetime] NOT NULL
CONSTRAINT [Tz0ID_PK] PRIMARY KEY CLUSTERED ([cod]))

work?

HTH,
Jim

Other Threads

1. Primary key when creating Interbase table

2. Create Access Tables with Primary Keys

3. Creating Primary Key on existing Interbase table

4. Modifing primary key after table created

5. Creating primary key for Access 97 tables

6. Number out of range error on Pdox table create w/autoinc primary key

7. Primary key or not primary key.........

8. Create primary key dynamic using SQL (I use access databas)

9. Newbie: Create primary key with ADOX

10. ADOX, Creating a Primary Key for Access 2000 DB