Board index » delphi » autoincrement with SQL in MS-Access-table

autoincrement with SQL in MS-Access-table

How to create a table with an autoincrement field in an MsAccess-table with
SQL CREATE TABLE (..) ??
 

Re:autoincrement with SQL in MS-Access-table


CREATE TABLE Customers
(
 CustId IDENTITY (1, 1) CONSTRAINT pkCustomers PRIMARY KEY,
 CFrstNm VARCHAR(10),
 CLstNm VARCHAR(15)
);

HTH
--
V. Nazarov
IT Manager, Sofia Cable

Re:autoincrement with SQL in MS-Access-table


Quote
>How to create a table with an autoincrement field in an MsAccess-table with
>SQL CREATE TABLE (..) ??

CREATE TABLE Table1 (Id COUNTER CONSTRAINT PrimaryKey PRIMARY KEY,
Text1 TEXT (10))

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads