Dropping Table in script

[#1]

Hi,

I want to create a dynamic environment, where the schema and table name keeps on  changing.

Issue:

I want to drop a table during partial reload. !

Can this be done ?

Can we write something like:

If(Tables Exists !)

     { Drop it! }

Else

{     Proceed }

Thanks & Regards

Swapneel

[Anonymous]

Try defining a variable for your table name

[pokassov]

Hello!

You can use this

if not isnull(TableNumber('your table name')) then

Sergey

[#4]

Hey Sergey,

Didnt follow you exactly, can you please elaborate. ?

Thanks 

Swapneel

[pokassov · Accepted solution]

Sure

if you have table with name "tab" and want to delete it,  than script will be

if not isnull(TableNumber('tab')) then

     { Drop it! }

Else

{     Proceed }

end if;

[#6]

Thanks Sergey
It works

Thanks a ton