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

4 votes350 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote341 views1 answer
What is between operator
SQL
0 vote319 views1 answer
Java spring boot connect to sql server
SQL
14 votes382 views3 answers
Inner join sql oracle
SQL
0 vote398 views1 answer
Trigger vérifier stock
SQL
4 votes308 views1 answer
Oracle sleep
SQL
1 vote356 views1 answer
Simple project for database
SQL
0 vote380 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
6 votes356 views1 answer
Wordpress change user password sql
SQL
3 votes342 views1 answer
Delete all content in table mysql
SQL