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 vote201 views1 answer
How to get last client id sql
SQL
-1 vote258 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote269 views2 answers
Drop tables from local table database postgres
SQL
0 vote268 views1 answer
Restore backup mysql .gz
SQL
0 vote258 views1 answer
Less than and between in sql query
SQL
0 vote267 views1 answer
Create table as select sql server error
SQL
0 vote262 views1 answer
MySQL get all previous date record
SQL
2 votes261 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote249 views1 answer
Excute raw query
SQL
0 vote289 views1 answer
Oracle pl/sql check if file exists
SQL