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 vote209 views1 answer
How to connect postgresql database with java
SQL
2 votes197 views1 answer
Sql find missing values between two tables
SQL
11 votes211 views2 answers
MySQL DISTINCT
SQL
0 vote218 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
2 votes252 views1 answer
Datefromparts mssql
SQL
1 vote206 views1 answer
Mysql find tables with column name
SQL
0 vote206 views1 answer
Sql string length postgresql
SQL
18 votes225 views6 answers
Creating table in MySQL
SQL
0 vote219 views1 answer
Partitioning in oracle-base
SQL
3 votes232 views1 answer
Increment integer in table sql
SQL