"View SQL" error when viewing Tables

Ameen

Member²
Hi.
When I use (View Table) window or (Edit Table) window and press "View SQL" button , the program does not display disabled constraints correctly. for example:

alter table ACCOUNTS
add constraint ACC_NAME_UK unique (NAME)
novalidate
disable;

where it should be:

alter table ACCOUNTS
add constraint ACC_NAME_UK unique (NAME)
disable
novalidate;

So the (disable) word must be before (novalidate).
 
Back
Top