→
→
ObJect Browser
select Raak-Ledger-Master
→
→
Constraint → Create
change the default constraint name
as RAAK-LEDGER-MASTER-CK2
against
constraint name
→ select Check against constraint type
→ select LEDGER-NAME against constraint on column
→ IS NOT NULL in constraint expression window
→ NEXT → Finish
Equivalent SQL script
ALTER TABLE RAAK-LEDGER-MASTER ADD CONSTRAINT "RAAK-LEDGER CHECK ( "LEDGER-NAME" IS NOT NULL )
To create ledger-code as uniqueness:
alter table raak-ledger-master add constraint raak-ledger-master-ukl unique (ledger-code);
To create ledger-name as uniqueness:
alter table raak-ledger-master add constraint raak-ledger-master-uk2 unique (ledger-name);