Product: Aqua Data Studio
Version: 16.0.0-dev-58
Build #: 41306
Build Date: 2014-Dec-02 06:00:02 PM
Operating Environment: Ubuntu-14.04LTS
Linux (3.13.0-37-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072; Total=447,217,664; Free=158,466,984; CPUs=8
Connect Syabse ASE-15.7
//Create table
CREATE TABLE "test_company" (
"empid" bigint DEFAULT 20 NOT NULL,
"c_name" varchar(100) DEFAULT 'dimentrix1' NOT NULL,
"c_address" varchar(25) DEFAULT 'dimentrix' NOT NULL,
CONSTRAINT "c_name" PRIMARY KEY CLUSTERED("c_name")
WITH max_rows_per_page = 0, reservepagegap = 0
)
LOCK ALLPAGES
GO
//Create procedure
CREATE PROCEDURE "test_procedure_company"
( @empid bigint, @c_name varchar(100), @c_address varchar(25) OUTPUT )
AS
BEGIN
SELECT COUNT(*) FROM dbo.test_company
END
GO
Right click on "test_procedure_company"
Select Script object to window as->
Here,you will observe that,CREATE OR REPLACE Parameter is not removed from list.
