sql anywhere create procedure

Solutions on MaxInterview for sql anywhere create procedure by the best coders in the world

showing results for - "sql anywhere create procedure"
Alexander
03 Jul 2020
1CREATE TEMPORARY PROCEDURE drop_table( IN @TableName char(128) )
2BEGIN
3    IF EXISTS  ( SELECT * FROM SYS.SYSTAB WHERE table_name = @TableName ) THEN
4   EXECUTE IMMEDIATE 'DROP TABLE "' || @TableName || '"';
5   MESSAGE 'Table "' || @TableName || '" dropped' to client;
6    END IF;
7END;
8CALL drop_table( 'CustRank' );