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

15 votes281 views4 answers
Export mysql db using command line
SQL
1 vote192 views1 answer
Sql insert for each distinct value
SQL
0 vote205 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote249 views1 answer
Sql check if field is not null
SQL
0 vote301 views1 answer
Contraint default SQL
SQL
0 vote205 views1 answer
Mysql Like(searching in the string)
SQL
2 votes211 views1 answer
How to make insert script from table in SQL server
SQL
3 votes192 views1 answer
How to remove characters from string in mysql
SQL
0 vote254 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote223 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL