Create table ID field

[Robert Orlini]

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]

---