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 vote128 views1 answer
Sql quary stuf
SQL
2 votes121 views1 answer
Query to find table size in oracle 12c
SQL
3 votes107 views3 answers
Mysql select table names
SQL
0 vote121 views1 answer
Oracle change password expiration policy
SQL
4 votes96 views2 answers
Linq join
SQL
0 vote99 views1 answer
How to fix mysql stop unexpectedly
SQL
6 votes115 views3 answers
Date_trunc postgres
SQL
7 votes109 views4 answers
Index in mysql
SQL
0 vote103 views1 answer
QUERY JPQL
SQL
0 vote113 views1 answer
Select even number id data from table
SQL