![Free-eBooks.net](/resources/img/logo-nfe.png)
![All New Design](/resources/img/allnew.png)
RAAK-TRANS-MASTER-UK1 against constraint name
→ select UNIQUE against constraint type
→ select VOUCHER-NUMBER against constraint on column
→ NEXT → Finish
Equivalent SQL script
ALTER TABLE RAAK-TRANS-MASTER ADD CONSTRAINT
"RAAK-LEDGER-MASTER-UKl" UNIQUE ( "VOUCHER-NUMBER" )
16.04 HOW TO CREATE FOREIGN KEY CONSTRAINT
A foreign key means that values in one table must also appear in another table, The referenced table is called the parent table while the table with the foreign key is called the child table, The foreign key in the child table will generally reference a primary key in the parent