[RESOLVED] create table , ms-access

[srisa]

Hello,
I want to create a table in ms-access database using SQL. Got an example while searching for it. For defining primary key constraint somthing like this has been used

CONSTRAINT sys_iu_primaryKey PRIMARY KEY(sys_u_id));

Somewhere else I found g_iu_primarykey. What is the difference between the two and when are they used?
Thank you.

[space_monkey]

If i remember correctly that is just a label; just a name for the constraint. You could call it whatever you want (i think). Most places have some type of naming convention, such as (TABLENAME_FIELDNAME_primaryKey). You might want to look up what is the common practice for naming your primary key constraint, and stick to that naming convention so that your database is well organized.

[srisa]

Thank you. That really helped.