Re: Which normal form is this violating?

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 7 May 2002 13:52:19 -0700
Message-ID: <c0d87ec0.0205071252.43daa9f6_at_posting.google.com>


>> Can you tell me when CREATE/ALTER/DROP DOMAIN were added to the SQL Standard? <<

SQL-92 >> Also, if I'm familiar with Oracle Rdb (formerly DEC Rdb) syntax for CREATE/ALTER/DROP DOMAIN is the SQL standard pretty much the same?
<<

Yep: here are the revelant sections of SQL-92

11.21 <domain definition>

Function

Define a domain.

Format

<domain definition> ::=

   CREATE DOMAIN <domain name> [ AS ] <data type>

     [ <default clause> ]
     [ <domain constraint>... ]
     [ <collate clause> ]

<domain constraint> ::=

   [ <constraint name definition> ]
   <check constraint definition> [ <constraint attributes> ]

11.22 <alter domain statement>

<alter domain statement> ::=

   ALTER DOMAIN <domain name> <alter domain action>

<alter domain action> ::=

     <set domain default clause>
   | <drop domain default clause>
   | <add domain constraint definition>
   | <drop domain constraint definition>

11.23 <set domain default clause>

<set domain default clause> ::= SET <default clause>

11.24 <drop domain default clause>

<drop domain default clause> ::= DROP DEFAULT

11.25 <add domain constraint definition>

<add domain constraint definition> ::=

   ADD <domain constraint>

11.26 <drop domain constraint definition>

<drop domain constraint definition> ::=

   DROP CONSTRAINT <constraint name>

11.27 <drop domain statement>

<drop domain statement> ::=

   DROP DOMAIN <domain name> <drop behavior> Received on Tue May 07 2002 - 22:52:19 CEST

Original text of this message