Re: repost of how to do select in a constraint

Thank you VERY, VERY much. Since I am in the planning stages of the database, and don't have
it sited yet, these few questions that I might be able to answer by playing around on a
database hold me up. By answering them, you on this list, Peter in particular, have really
moved my development forward.

1/21/2003 10:11:41 PM, "Peter Gibbs" <peter(at)emkel(dot)co(dot)za> wrote:

>Dennis Gearon wrote:
>
>> Can I reference a function in a column check constraint, when the function
>doesn't yet exist,
>> i.e. a the time of table creation?
>>
>> Or is it better to make the table, create the function, then alter table
>with a check
>> constraint?
>
>The function has to exist before the constraint is created. If the function
>depends on the table that will have the constraint, you will need to add the
>constraint afterwards; however, if the function only depends on other
>tables, then you can create the function before creating the table.
>--
>Peter Gibbs
>EmKel Systems
>
>