Skip to Content
author's profile photo
Former Member

u3010ask for helpu3011The syntax of EXISTS in MaxDB

In MS SQL Server, we can :

if exists (select * from B)

Drop table B

But ,if MaxDB, I found if can not be used with exists, and exists will not have these functions.

So, is there anyone can teach me how to implement similar operation in MaxDB with EXISTS?

Thank you very much!!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on Aug 21, 2007 at 05:01 PM

    Hi Xuan,

    the EXIST clause is available in MaxDB, but the feature you make use of here is the procedural enhancement of SQL by MS SQL Server.

    Basically it's a small procedural IF...THEN... clause.

    You can do it also in MaxDB, but you would have to create a dbproc for this and call the dbproc afterwards.

    So either use that dbproc approach or implement the procedural logic in the front-end.

    KR Lars

    Add comment
    10|10000 characters needed characters exceeded