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

-1 vote163 views1 answer
Mysql case when multiple conditions
SQL
0 vote164 views1 answer
Mysql function variable
SQL
10 votes186 views1 answer
How to import database in mysql by cmd
SQL
48 votes278 views3 answers
Psql create database
SQL
2 votes174 views1 answer
How to check if a row is null in sql
SQL
79 votes535 views6 answers
Grepper code
SQL
14 votes180 views2 answers
Install mysqldump
SQL
0 vote174 views1 answer
Postgresql default value boolean
SQL
0 vote234 views3 answers
Mysqli count down
SQL
0 vote165 views1 answer
2020 new year
SQL