Primary Key Index in Make Table Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

William - 17 Sep 2006 02:33 GMT

I have a Make Table Query which makes a table called "Companies." The source
for the query is a table named "Outlook." I wish to make a one of the fields
which is created in table "Companies" a Primary Key Index. How can I do this?

Reply to this Message

Granny Spitz - 17 Sep 2006 03:51 GMT

> I wish to make a one of the fields
> which is created in table "Companies" a Primary Key Index. How can I do this?

By running a second query that uses DDL SQL to alter the table after you run
the make table query. You need to create a new query and open it in SQL view
to type this yourself, hon. I don't know which column and data type you want
your primary key to be, but here's an example of an AutoNumber called ID:

ALTER TABLE Companies
ALTER COLUMN ID COUNTER
CONSTRAINT PrimaryKey PRIMARY KEY;

Reply to this Message

William - 17 Sep 2006 05:51 GMT

Thanks for your Help!!!!

> > I wish to make a one of the fields
> > which is created in table "Companies" a Primary Key Index. How can I do this?
[quoted text clipped - 7 lines]
> ALTER COLUMN ID COUNTER
> CONSTRAINT PrimaryKey PRIMARY KEY;

Reply to this Message

Granny Spitz - 17 Sep 2006 07:16 GMT

>Thanks for your Help!!!!

You're welcome, William! : )

Reply to this Message