Create table query

  • Thread starter Thread starter Guest
  • Start date Start date
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

CREATE TABLE MyTable (
MyAutoNumberColumn Counter,
Column1 Integer
)

In JET SQL the data type for an AutoNumber column is "Counter."

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQMi/boechKqOuFEgEQIXOgCgyyxxCRynuW4uPYNoBZMATTRgyT0Anj0j
WzkaKAnfJOTfVxjJ0tdaEFTk
=6uUb
-----END PGP SIGNATURE-----
 

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

Append query - Append to table with Autonumber field 2
Trouble with Query Results 11
adding a field in a make table query 5
Make Table Query and Autonumber Fields 6
Create table query... want to insert autonumber column 3
Links in Query results 3
Append Query: SQL to add a new record? 7
Make-table query with around 2 ml records taking too long 0

Back
Top