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

1 vote323 views1 answer
SQL server query column yes or no
SQL
10 votes344 views4 answers
Drop primary key
SQL
0 vote312 views1 answer
Install ms sql server management studio
SQL
1 vote344 views1 answer
ORA-01950
SQL
1 vote325 views1 answer
Postgresql contains
SQL
0 vote329 views1 answer
Sql include rows with 0 values
SQL
0 vote368 views2 answers
Identity syntax in sql
SQL
0 vote329 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
29 votes320 views6 answers
Delete all rows from table mysql
SQL
0 vote350 views1 answer
Procedure excute monthly oracle
SQL