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 vote234 views1 answer
Mysql create index lost connection
SQL
20 votes178 views5 answers
Mysql reset auto increment to 1
SQL
0 vote190 views2 answers
Plsql function that return a table
SQL
0 vote179 views1 answer
Postgres get running query
SQL
2 votes194 views2 answers
How to view created temporary tables in mysql
SQL
0 vote202 views1 answer
Ver usuarios mysql
SQL
0 vote200 views1 answer
Mysql zerofill
SQL
1 vote184 views1 answer
User privileges postgresql information_schema
SQL
0 vote185 views1 answer
Sql roll up rows into columns
SQL
0 vote148 views1 answer
Denied
SQL