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

5 votes309 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
-1 vote345 views1 answer
Get month and year from date in mysql sequelize
SQL
2 votes271 views1 answer
Oracle sql drop column if exists
SQL
1 vote307 views1 answer
Mysql tables max count
SQL
0 vote298 views1 answer
T sql less than date
SQL
2 votes315 views1 answer
Flask sqlalchemy boolean field
SQL
-1 vote295 views1 answer
Add bool column in sql
SQL
1 vote300 views1 answer
Order by oracle
SQL
4 votes321 views3 answers
Sql drop database if exists
SQL
0 vote296 views1 answer
Sql select inside select sub query
SQL