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

6 votes191 views3 answers
Update with inner join postgres
SQL
8 votes227 views2 answers
Sqlsrv default port
SQL
0 vote243 views1 answer
Postgresql cast as year and month from timestamp
SQL
6 votes185 views1 answer
Oracle desc table primary key
SQL
0 vote187 views1 answer
Import big data to mysql
SQL
1 vote376 views1 answer
Postgres convert text to number
SQL
2 votes229 views1 answer
Match in sql server
SQL
2 votes192 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote172 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote225 views1 answer
Homebrew install mysql
SQL