CREATE TABLE "deleteion" control

[Rodrigo Hjort]

I believe it has something to do with foreign key (FK) definitions and it is
a SQL standard.

i.g., in MS-SQL Server:

Action applied to the foreign key when the SQL operation is an update.
0 = CASCADE changes to foreign key.
1 = NO ACTION on changes if foreign key is present.
2 = SET_NULL; set foreign key to NULL.

Regards,

Rodrigo Hjort
rodrigo.hjort at actumplus.com.br


-----Mensagem Original-----
De: "Andrew Sinning" <andrew at learningware.com>
Para: "Valentina Developers" <valentina at lists.macserve.net>
Enviada em: terça-feira, 19 de agosto de 2003 14:59
Assunto: CREATE TABLE "deleteion" control


> In the ValentinaSQL.pdf, under CREATE TABLE, there as entry for
> "deleteion_control"
>
> : "on delete" { "set null" | "restrict" | "cascade" }
>
> What does this do?  All of my db experience is with MySQL, so I'm not
> familiar with this specification.
>
> Thanks!