Hello,

I agree exists in the DDL would be nice, but I am also a long-time Sybase user. In the mean time, for my code I am doing a select from SYS.SYSTABLES to check for existence. Something like :

   select count(*) from SYS.SYSTABLES where TABLENAME = 'MY_TABLE'

The only thing that goofed me up was the MY_TABLE is in all caps even if not created that way. Unfortunately, this does not work in the SQL-only ant environment you described.

Thanks;
 -- Matt Sanford

[EMAIL PROTECTED] wrote:

Hi there,

Thank you guys for the advice.

I just wanted to prepare a file having those SQL statements and process it using ANT, but now I gotta implement it programmatically..

Can you guys put this functionality in wishlist ???

Thanks anyways !

Regards,
Wolfgang




__________________________________
For All Sports Fans!
http://pr.mail.yahoo.co.jp/yells/



Reply via email to