Dropping A Table

#1

Hi, everyone.
My simple question about dropping table.
How can i control a table if existing in database before dropping?
Example:
Drop Table tmpTable;
Create Table tmpTable....

...if tmpTable not exist, my batch query doesnt works and i must
control
it before dropping.

Thanks for everyone.

#2

Don't use a batch query -- use two separate statements, and if the DROP
statement fails, simply ignore the error.
BB

sectatrix (AT) gmail (DOT) com wrote:

Quote:

Hi, everyone.
My simple question about dropping table.
How can i control a table if existing in database before dropping?
Example:
Drop Table tmpTable;
Create Table tmpTable....

...if tmpTable not exist, my batch query doesnt works and i must
control
it before dropping.

Thanks for everyone.

#3

Thanks Bill for your help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Dropping A Table

comp.databases.btrieve comp.databases.btrieve

Dropping A Table - 09-20-2006 , 06:42 AM

Re: Dropping A Table - 09-20-2006 , 11:00 AM

Re: Dropping A Table - 09-21-2006 , 04:01 AM