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 vote261 views1 answer
Formatting code with SQL Developer
SQL
0 vote271 views3 answers
Classement rang mysql 7
SQL
0 vote274 views1 answer
Mysql grouping functions
SQL
0 vote248 views1 answer
Time in sql server
SQL
1 vote250 views1 answer
Clear screen command in psql
SQL
2 votes249 views1 answer
Mysql sysdate
SQL
1 vote282 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
4 votes840 views1 answer
Oracle show errors
SQL
0 vote269 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote286 views1 answer
Vs 2019 connect to local mysql database
SQL