Go to the Home → SQL Workshop → SQL Command
Window … type
ALTER TABLE RAAK-TRANS-DETAIL ADD CONSTRAINT "RAAK-TRANS-DETAIL-PK" PRIMARY KEY ("RECORD-ID") CLICK RUN will alter the table
Once we declare or define the primary key , it needs to be populated with sequence number generated by Oracle Sequence object through "TRIGGER"
16.02 HOW TO CREATE CHECK CONSTRAINT
It is another constraint altering the table structure, Hence, having created table one need to use ALTER TABLE command,
Required Business Rule for Ledge-Master: In Ledger-Master table, where in one column named as Report-Type and the data type declared as CHAR( 2 ), Allowable data is only 'BS' or 'PL', Which indicate BS as Balance Sheet and PL as Profit and Loss, If any other data tries to enter in the table database should reJect the