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 vote193 views3 answers
Sql server import json
SQL
3 votes177 views1 answer
Pl sql check if variable is empty
SQL
0 vote201 views1 answer
Get record which is available in one table but not in another mysql
SQL
2 votes304 views2 answers
How to DROP a table in mysql
SQL
1 vote194 views1 answer
Oracle sql average
SQL
0 vote249 views2 answers
Mysql cast to varchar
SQL
0 vote237 views1 answer
Postgresql alter table sequence
SQL
0 vote151 views0 answer
SQL
7 votes193 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote196 views1 answer
Mysql Digital Ocean connection problems
SQL