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 vote275 views1 answer
Select inside insert query
SQL
0 vote273 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
4 votes275 views3 answers
How to describe a table in sqlite3
SQL
0 vote287 views1 answer
How to to get time in sql
SQL
0 vote287 views1 answer
Mysql multiple group by
SQL
0 vote269 views1 answer
Order by number of character in sql
SQL
0 vote264 views1 answer
How to remove default in mysql
SQL
-1 vote248 views2 answers
Sql query examples
SQL
1 vote291 views1 answer
Name of today sql
SQL
0 vote297 views1 answer
Providername system.data. mysql
SQL