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 vote319 views1 answer
How to get table id sequence postgres
SQL
0 vote290 views1 answer
Android sqlite add column if not exists
SQL
2 votes298 views1 answer
Mysql application.properties spring boot
SQL
0 vote284 views1 answer
Mysql create pool
SQL
8 votes292 views1 answer
How to remove tables from postgresql
SQL
0 vote297 views1 answer
Postgresql delete limit
SQL
-1 vote266 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote296 views1 answer
Sql sum show 0 result
SQL
2 votes304 views1 answer
Mysql set value as null
SQL
1 vote296 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL