How are primary keys used in SPS?
SPS depends heavily on primary keys. • When creating new records in the SPS Content Administrator, a new primary key is generated for each new record. • When updating records in the SPS Content Administrator, records are located by the primary key. • When generating content pages, file names for the pages are generated from the primary key. How do I create a primary key for tables in the database? The answer to this will vary somewhat depending on the database engine, but typically primary keys are described in the SQL to create a table, i.e. CREATE TABLE Artist ( artistId INTEGER PRIMARY KEY, artistName VARCHAR(255) ); In this case, the artistId is a primary key. Note that primary keys need not be integers. How are primary keys generated? SPS gives you three options for generating primary keys. PRIMARY_KEY_GENERATE=AUTO Automatic primary key generation may be used if the database supports “serial” fields. Serial fields will automatically create unique numeric primary keys for each rec
