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 vote313 views1 answer
Sql server manager close connection
SQL
0 vote332 views1 answer
Sql date time query find
SQL
0 vote305 views1 answer
Get who is hired in specific month in sql
SQL
0 vote329 views1 answer
Product of a column in mysql
SQL
0 vote325 views2 answers
Search stored procedures
SQL
-1 vote323 views1 answer
Mysql case when multiple conditions
SQL
1 vote319 views1 answer
Postgresql escape single quote
SQL
0 vote310 views1 answer
Sqlalchemy query join many to many
SQL
5 votes333 views2 answers
To date oracle
SQL
0 vote344 views2 answers
Generate sql trigger through ef migration
SQL