Sql anywhere create procedure

CREATE TEMPORARY PROCEDURE drop_table( IN @TableName char(128) )
BEGIN
    IF EXISTS  ( SELECT * FROM SYS.SYSTAB WHERE table_name = @TableName ) THEN
   EXECUTE IMMEDIATE 'DROP TABLE "' || @TableName || '"';
   MESSAGE 'Table "' || @TableName || '" dropped' to client;
    END IF;
END;
CALL drop_table( 'CustRank' );

Source: dcx.sybase.com

Similar codes

0 vote182 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
1 vote215 views1 answer
Date in where on datetime column clause mysql
SQL
1 vote177 views1 answer
Mysqli connect
SQL
0 vote197 views1 answer
Exectuer myssql .sql
SQL
15 votes182 views2 answers
How to drop database name in postgresql
SQL
0 vote196 views1 answer
Partitioning in oracle-base
SQL
59 votes313 views6 answers
Alter table sql
SQL
12 votes183 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote188 views1 answer
Declarative base sqlalchemy
SQL
22 votes192 views2 answers
Mysql show all tables
SQL