Printable View
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.
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.
Thank you. That really helped.