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 vote149 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote147 views1 answer
Mysql 8 error on identified by
SQL
0 vote135 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote146 views1 answer
Mysql update from select on same table
SQL
3 votes137 views2 answers
Sql add year to date
SQL
0 vote142 views1 answer
Declarative base sqlalchemy
SQL
1 vote138 views1 answer
Python escape mysql
SQL
0 vote132 views1 answer
How to use query in nosql
SQL
0 vote142 views1 answer
My sql data file extention
SQL
0 vote134 views1 answer
Postgres : ERROR: division by zero
SQL