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 vote122 views1 answer
Tsql cmd exec script from file
SQL
3 votes130 views1 answer
Make a field auto_increment mysql
SQL
1 vote112 views1 answer
Sql alchemy with azuresql server
SQL
1 vote116 views1 answer
Mysql batch insert
SQL
0 vote123 views1 answer
Search from comma separated values in sql server
SQL
3 votes110 views1 answer
Oracle nextval
SQL
1 vote183 views1 answer
Mysql stop password policy
SQL
1 vote120 views1 answer
Create procedure with encryption
SQL
0 vote143 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote169 views1 answer
Creating sqeuence in oracle database
SQL