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

-1 vote408 views4 answers
Sql view postgresql
SQL
3 votes362 views2 answers
Get current year sql
SQL
0 vote376 views4 answers
Rownum in sql
SQL
1 vote410 views1 answer
UseSqlServer no definition
SQL
0 vote343 views1 answer
Convert sql server guid to varbinary
SQL
3 votes340 views1 answer
Search for column name in psql
SQL
0 vote390 views1 answer
Neo4j command to run script file
SQL
0 vote358 views2 answers
How to use aggregate functions in sql
SQL
0 vote353 views1 answer
Get who is hired in specific month in sql
SQL
1 vote340 views1 answer
Oracle list constraints
SQL