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 vote204 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote204 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote199 views1 answer
Mysql show category once count how many products
SQL
0 vote213 views1 answer
Suse status MySQL
SQL
3 votes217 views1 answer
Postgres select max value
SQL
0 vote265 views1 answer
What is common table expression in sql
SQL
1 vote209 views1 answer
Mysql show database size in mb
SQL
0 vote218 views1 answer
Mysql exception output
SQL
9 votes194 views2 answers
Sql limit order by
SQL
1 vote202 views1 answer
Size of all tables in a schema oracle
SQL