if table exists functionality

[oxenberg]

Hi,

I need to modify a script such that if a table exists I drop it and recreate it and if it doesn't exist I just create it. How do I do this? I've searched the help but I'm still stuck. Thanks

Phil

 

[ManuelPallas]

if you are using sqlbase, take a look in the table SYSTABLES. there you can find all existing tables of the databse..

 

[OliverA]

You can implement a stored procedure on the splbase which contains the functionality to drop a table or receatea table. To decide wether drop or create you can have a look into the syscatalog ( sysadm.systables ).
Now it's very simple to execute the procedure with table name and DDL script as parameter.

Oliver