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>)

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP PowerDesigner (PD) 16.6

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