T-SQL syntax: Primary key index

J

jpm

Hi,

I'm using Vb6/ADO 2.6 to create a table in a Jet db and I need a
multi-column primary key? I can't seem to find the syntax for doing this.
Can I do it with the CREATE TABLE statement or can I do it by creating a
primary key index?

I can find the info to effect this with SQL Server; what is it for Jet
db's?

Thanks,

Jim M.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
VBA word change keys 0
Insert Index into a Table 1
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Create Foreign Keys 1
How to (in vba code) identify if a linked ODBC table has a primary 6
Set primary key on a temp database table 3
Index/Primary Key Error Handler 1

Top