Multiple Create Table Query

[tubbsy123]

Hi,

I wonder if you could help me. I am making a query which creates 3 tables. I come from an Oracle SQL background, where you can write multiple Create Table queries. Unfortunately this doesn't seem to be the case with Access.

Can anybody explain how to do this in Access please?

A simplified version of my tables are:

Create Table Gains(
PES Text (255),
OldSupplier Text (255),
Month Date);

Create Table Loss(
PES Text (255),
OldSupplier Text (255),
Month Date);

Create Table Mid(
PES Text (255),
OldSupplier Text (255),
Month Date);

I do not require any constraints or primary keys within these tables.

I hope this is enough information.
Thankyou for your help

Regards

Tubbsy123

 

[r937]

you do it the same way in access, although the DDL is sllightly different

see

http://support.microsoft.com/kb/q180841/

not sure if you can submit more than one statement at a time, though (as in other databases, where you can string several statements together with, for example, semi-colons)

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)