Subject Re: [firebird-support] To add Primary Key
Author Thomas Steinmaurer

> What is the difference and which one is better?
> Alter Table REF_STA add Primary Key (STA_CDE);
> Alter Table REF_STA add Constraint pk_REF_STA Primary Key (STA_CDE);

The latter, because you give the primary key constraint a meaningful name.

In your first example, the primary key constraint gets a system name,
which you need to lookup in the system tables, if, for instance, you
want to drop the primary key constraint.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions