ID key in SQL table

[Robert Orlini]

How do I create an SQL table and assign an Identity key in the syntax?

What I have so far worked well with Access but will not work for SQL:

Create table MTM
(ID COUNTER not NULL PRIMARY KEY,
Orderdate Char (50) not null,
Institution Char (50) not null,
Customer Char (50) not null)

THX.

Robert O.
HWW

---

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

---