If you're using SQL Server;
IDfield identity primary key
You could expand it further
IDfield int identity(1,1) primary key
But they do the same thing
> -----Original Message-----
> From: Robert Orlini [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 02, 2004 10:53 AM
> To: CF-Talk
> Subject: Create table ID field
>
>
> I have this code to create a table in a cfm file:
>
> <CFQuery datasource="test" name="#trialname#">
> Create table #trialname#
> (Orderdate Char (50) not null,
> Institution Char (50) not null,
> Customer Char (50) not null,
> address Char (50) not null,
> city Char (10) not null,
> state Char (10) not null,
> zip Char (5) not null,
> phone Char (8) not null,
> login Char (10) not null,
> email1 Char (50) not null)
> </CFQUERY>
>
> What is the code to add a primary key ID field?
>
> Thx.
>
> Robert O.
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
