Subject | Know if a table exist before create |
---|---|
Author | donjules2k |
Post date | 2004-07-13T16:34:56Z |
Is there a way to know if a table exists before I create it?
I can run an "if" statement in a stored proc to check if it exists in
the RDB$ tables but then I can't run the create statement as that is
not allowed in a stored proc.
In isql, i can run the create but not the IF to check the table does
not exists.
So how do I do this?
Thanks
Giulio
I can run an "if" statement in a stored proc to check if it exists in
the RDB$ tables but then I can't run the create statement as that is
not allowed in a stored proc.
In isql, i can run the create but not the IF to check the table does
not exists.
So how do I do this?
Thanks
Giulio