Subject Self Reference Error? Bug?
Author dcabbar

I am trying to execute the following SQL which has self-reference:

create table ExampleTable (
code integer not null primary key,
name varchar(100) not null unique,
parent integer,

foreign key (parent) references ExampleTable(code)

And, this throws an error like:

This operation is not defined for system tables.
unsuccessful metadata update.
object EXAMPLETABLE is in use .

Is this a bug?