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 vote328 views2 answers
How to count codition
SQL
0 vote296 views1 answer
Postgresql conectar
SQL
0 vote296 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote315 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
1 vote351 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote291 views1 answer
Mysql terminal list table
SQL
0 vote303 views1 answer
Load utilities in sql server
SQL
0 vote669 views1 answer
Sql field equals multiple values
SQL
0 vote318 views1 answer
How to delete python anywhere mysql database
SQL
3 votes310 views1 answer
Oracle failed login attempts
SQL