Par2: Creating Primary Key in SQL file from Clarion 1998-06-04 -- Scott Ferret > when I CREATE an ORACLE file in a C4BM program, and one of the keys has the > PRIMARY attribute, I would expect the the field(s) of this key to be marked > as primary key field(s) in Oracle. > CREATE creates unique indexes. If you want to create primary key constraints you need to use PROP:SQL to do the create. Note that you should always use PROP:SQL to do a create as the Clarion CREATE statement cannot handle all the features of the SQL CREATE TABLE statement. Eg constraints on fields and foreign keys. Printed May 3, 2024, 7:29 pm This article has been viewed/printed 35115 times. |