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

3 votes132 views1 answer
Sql double index
SQL
0 vote128 views1 answer
Postgres create extension if not exists
SQL
0 vote136 views3 answers
Sql delete all except
SQL
12 votes137 views4 answers
Psql command not found
SQL
0 vote122 views1 answer
Automate mysql cli query
SQL
1 vote141 views1 answer
Retrieve meaning
SQL
1 vote139 views2 answers
Mysql update table from another table
SQL
25 votes119 views1 answer
Mysql grant all privileges to a user
SQL
0 vote121 views1 answer
Mysql start of today
SQL
3 votes140 views5 answers
Sql select
SQL