psGDropProcedures

Description

     This program drops stored procedures and functions in a database.

Syntax

psGDropProcedures -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname
-Hschema_name -Fsql_script -Ooptions

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User's Password

-D

Sybase Database

-W

Drop Procedures belonging to owner only

-N

Drop Procedures having pattern 'name' [!rs%]

-H

Schema name (optional)

-F

Name of output SQL script [standard output]

-O

Options

s

Sybase

o

Oracle

m

Microsoft SQL Server

i

Informix

r

Postgres

y

MySQL

g

ODBC

DSQUERY

When -S is not specified.

SYB_USER

When -U is not specified.

SYB_PASS

When -P is not specified.

SYB_DATABASE

When -D is not specified.

PS_SYSMSG_FILE

Name of the tool's messages file.