RE: Create table ID field

[Matt Robertson]

Here's an example for an Access table, where the primary key is an
autonumber field, and there's a separate index as well.

<cfquery
datasource="#request.blahblah#">
CREATE TABLE myfile (
  ID COUNTER not NULL PRIMARY KEY,
  ParentID number NULL,
  LinkID number NULL,
  Slot number NULL ,
  ItemType text(10) NULL
);
</cfquery>
<cfquery
datasource="#request.blahblah#">
CREATE INDEX ParentID on myfile(ParentID);
</cfquery>

--------------------------------------------
Matt Robertson       [EMAIL PROTECTED]
MSB Designs, Inc.  http://mysecretbase.com
--------------------------------------------

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---