Re: What is this trying to do...

gore_at_intersystems.com (cg) wrote in message news:<747dbee0.0212260914.3aa52c5e_at_posting.google.com>...
> Hi -
>
> I'm not certain what this Create Table statement on Oracle 8.1.7 is
> doing (it doesn't look like leagle SQL to me, but I'm not certain)
>
> CREATE TABLE WB_RT_TIME_SRC
> (
> ID_COL NUMBER NOT NULL,
> CONSTRAINT SYS_IOT_TOP_288891
> PRIMARY KEY (ID_COL) ENABLE VALIDATE
> )
 ...
> /
>
>
> It's the "CONSTRAINT SYS_IOT_TOP_288891" bit that confuses me. I'm
> working on documenting some SQL that we have inherited, and this
> is throwing me for a loop.
>
> Thanks in advance

This looks like a valid create table statement. The 'SYS_IOT_TOP_288891' is simply the constraint name, and looks like a system generated name. If you remove it, the system will generate another similar looking constraint name. You see this when people do not originally specify constraint name, and then use software to generate scripts to regenerate database objects. You should replace the name with something more meaningfull (ie. PK_WB_RT_TIME_SRC ).

Guy Received on Fri Dec 27 2002 - 15:20:24 CET