Board index » delphi » Create Access Tables with Primary Keys

Rodney Bagley

Delphi Developer
Fri, 05 Dec 2003 20:13:18 GMT

Create Access Tables with Primary Keys

I wrote a program using ADOExpress and a Access database. Now I create my
database and tables on the fly if not found. But I need a way to create
primary keys for these tables can anyone help me?
 
Esteban Ol

Delphi Developer
Fri, 05 Dec 2003 22:47:02 GMT

Re:Create Access Tables with Primary Keys


Look the MSAccess Help, at the CREATE help. This is from the help:

CREATE TABLE Amigos
(
[IdAmigo] Integer,
[Apellido] Text,
[Nombre] Text,
[FechaDeNacimiento] date,
[Telfono] Text,
[Nota] memo,
PRIMARY KEY ([IdAmigo])
);

Rodney Bagley <rbag...@imageright.com> escribi en el mensaje de noticias
3b2def4d_1@dnews...

Quote
> I wrote a program using ADOExpress and a Access database. Now I create my
> database and tables on the fly if not found. But I need a way to create
> primary keys for these tables can anyone help me?

Brian Bushay Team

Delphi Developer
Sat, 06 Dec 2003 13:17:41 GMT

Re:Create Access Tables with Primary Keys


Quote
>I wrote a program using ADOExpress and a Access database. Now I create my
>database and tables on the fly if not found. But I need a way to create
>primary keys for these tables can anyone help me?

With SQL use

ALTER TABLE tblCustomers
   ALTER COLUMN CustomerID INTEGER
   CONSTRAINT PK_tblCustomers PRIMARY KEY

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

Other Threads

1. Creating primary key for Access 97 tables

2. Primary key when creating Interbase table

3. Create primary key dynamic using SQL (I use access databas)

4. ADOX, Creating a Primary Key for Access 2000 DB

5. primary key on create table?

6. Creating Primary Key on existing Interbase table

7. Modifing primary key after table created

8. Creating primary key in access

9. ADOX: Creating a Primary Key for an Access 2000 DB

10. Number out of range error on Pdox table create w/autoinc primary key