Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...

Articles Figures Tables About

Domains, Triggers, and Views

There are other features of SQL that are useful for chemical relational databases. Domains, triggers, and views are objects that belong to a schema just as tables and functions. These are also discussed in later chapters that focus on practical uses. [Pg.28]

An SQL domain is an extension of one of the built-in data types, but includes an optional check constraint. For example  [Pg.28]

Create Domain smiles As Text Check (valid(Value))  [Pg.28]

An SQL trigger is also useful to ensure that only valid data appears in a table. For example  [Pg.28]

Create Trigger standardize Before Insert Or Update On atable For Each Row Execute Procedure standardize()  [Pg.28]


See other pages where Domains, Triggers, and Views is mentioned: [Pg.28]   


SEARCH



Triggerable

Triggers

© 2024 chempedia.info