IF EXISTS statement

MikeHorn

New Member
Progress 9.1D06
Win2K

Using SQL Explorer the following SQL92 statement keeps returning a syntax error.
Why?

IF EXISTS (SELECT tbl FROM sysprogress.systables WHERE "tbl" = 'DESPHIST2')
DROP TABLE pub.DESPHIST2;

Any and all advice gratefully received!

TIA
Mike
 
Top