Chapter 3 DBMS Reference Guide

Drop

Statement for dropping an object (generation only).

Example

In Sybase Adaptive Server Anywhere 6:

if exists(select 1 from sys.systable where table_name='%TABLE%' and table_type='BASE'[%QUALIFIER%? and creator=user_id('%OWNER%')]) then
    drop table [%QUALIFIER%]%TABLE%
end if

Copyright (C) 2005. Sybase Inc. All rights reserved.