2867849 - How to add a key using the ALTER TABLE statement - SAP PD

• How to generate a primary, an alternate or a foreign key with a separate SQL command, generally using an ALTER command after the creation of the table.
• Syntax:

ALTER TABLE <table_name> ADD CONSTRAINT <constraint_name> PRIMARY KEY (<column_name>)

SAP PowerDesigner (PD) 16.6

pk, fk, ak, index, reference, inside , KBA , BC-SYB-PD , PowerDesigner , How To