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 vote258 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote244 views1 answer
Sqlalchemy get schema from database
SQL
0 vote266 views1 answer
Sql cursor example multiple columns
SQL
1 vote233 views1 answer
Does insert into overwrite sql
SQL
18 votes246 views6 answers
Creating table in MySQL
SQL
1 vote232 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote241 views1 answer
Mysql subdate
SQL
0 vote258 views1 answer
Dataframe lambda elif
SQL
4 votes213 views1 answer
Postgresql show current database
SQL
0 vote223 views1 answer
Double in sql server example
SQL