psListTriggers

Description

     This program lists all the triggers in a database.

 

Syntax

psListTriggers -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname -Ttable -Foutput_file -Ooptions

 

Arguments

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User's Password

-D

Sybase Database

-W

List triggers belonging to owner only

-N

List triggers having pattern 'name'

-T

List triggers only on table having names patterned after 'table'

-F

Name of output trigger's list file [standard output]

-O

Options

 

Options

l

List names of triggers only

t

Print the text of each trigger

 

Environment Variables Behind the Scenes

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

 

Go to DBPowerSuite 7.9 List of Programs.


Updated: Thu Jun 18 21:12:26 2009