Syntax on Create Table...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 10 Nov 2005 23:07 GMT

Where can find the syntax on Create Table...?

I need to use Create Table... statement to create a access table with an
Autonumber column as PK.

Thanks!

Reply to this Message

Chris2 - 10 Nov 2005 23:18 GMT

> Where can find the syntax on Create Table...?
>
> I need to use Create Table... statement to create a access table with an
> Autonumber column as PK.
>
> Thanks!

Do a search on your c: drive for JETSQL40.chm.

Open the file, click on the index tab, and
type in CREATE TABLE, and then hit enter, and
then select "CREATE TABLE Statement
(Microsoft Jet SQL)"

This will show the syntax of CREATE TABLE

Sincerely,

Chris O.

Reply to this Message

chilling - 11 Jan 2006 19:49 GMT

I can not find any info on how to add a field which has a type of autotype ....

my query so far is:

CREATE TABLE tblAccTransLog (
AccTransLogID INTEGER PRIMARY KEY,
TransType INTEGER,
TransNo TEXT(50),
DateCreated DATETIME,
AccRef TEXT(50),
B2BComplete BIT);

I want AccTransLogID to be an autonumber field what do I need to add to the
above statement?

Reply to this Message

Michel Walsh - 11 Jan 2006 20:21 GMT

Hi,

use COUNTER or AUTOINCREMENT instead of INTEGER

With Jet 4.0 and ADO, you can also use IDENTITY and an optional seed and
increment too, as in

columnName AUTOINCREMENT( 1, 1 )

Hoping it may help,
Vanderghast, Access MVP

>I can not find any info on how to add a field which has a type of autotype
>....
[quoted text clipped - 12 lines]
> the
> above statement?

Reply to this Message

chilling - 12 Jan 2006 15:23 GMT

> use COUNTER or AUTOINCREMENT instead of INTEGER

Thanks that did it :)

Just for completion sake the code is:

CREATE TABLE tblAccTransLog2 (
AccTransLogID AUTOINCREMENT( 1, 1) PRIMARY KEY,
TransType INTEGER,
TransNo TEXT(50),
DateCreated DATETIME,
AccRef TEXT(50),
B2BComplete BIT);

Reply to this Message