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

5 votes142 views1 answer
List foreign key oracle
SQL
0 vote156 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote151 views1 answer
Mysql count with two joins
SQL
0 vote151 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
1 vote159 views1 answer
Change table to innodb mysql
SQL
0 vote180 views1 answer
Mysql bind-address default value
SQL
0 vote152 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote189 views1 answer
For select oracle
SQL
23 votes155 views4 answers
How to uninstall postgresql in ubuntu
SQL
-1 vote183 views2 answers
Sql search all tables for attributes
SQL