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 votes197 views1 answer
Oracle get foreign keys on table
SQL
1 vote201 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
1 vote194 views1 answer
Mysql change root mysql_native_password
SQL
1 vote202 views3 answers
Epoch to datetime
SQL
0 vote234 views1 answer
Reindexing all tables sql server
SQL
0 vote236 views1 answer
SQL Cut part string
SQL
1 vote199 views1 answer
Psql lst trigger
SQL
0 vote182 views1 answer
Sql server split string and insert into table select
SQL
10 votes142 views2 answers
Django mysql
SQL
2 votes208 views1 answer
Drop all foreign key constraints mysql
SQL