Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

List of Triggers

3 posts in General Discussion Last posting was on 2008-09-13 08:04:43.0Z
Manmaria Posted on 2008-09-12 17:24:49.0Z
From: "Manmaria" <officialinquiry@gmail.com>
Newsgroups: ianywhere.public.general
Organization: 159.140.254.10
X-Newsreader: AspNNTP 1.50 (JodoHost)
Subject: List of Triggers
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48caa5e1$1@forums-1-dub>
Date: 12 Sep 2008 10:24:49 -0700
X-Trace: forums-1-dub 1221240289 10.22.241.152 (12 Sep 2008 10:24:49 -0700)
X-Original-Trace: 12 Sep 2008 10:24:49 -0700, vip152.sybase.com
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7084
Article PK: 5306

How do I find the list of non system triggers?
TIA
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Jeff Gibson Posted on 2008-09-13 08:04:43.0Z
Reply-To: "Jeff Gibson" <jgibson@interceptsolutions.com>
From: "Jeff Gibson" <jgibson@interceptsolutions.com>
Newsgroups: ianywhere.public.general
References: <48caa5e1$1@forums-1-dub>
Subject: Re: List of Triggers
Lines: 23
Organization: Intercept Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-Rfc2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48cb741b$1@forums-1-dub>
Date: 13 Sep 2008 01:04:43 -0700
X-Trace: forums-1-dub 1221293083 10.22.241.152 (13 Sep 2008 01:04:43 -0700)
X-Original-Trace: 13 Sep 2008 01:04:43 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7086
Article PK: 5305

Are you talking about triggers in SQL Anywhere, or ASE?

In SQL Anywhere....

SYSTRIGGERS consolidated view

select * from that view gives you a full list. You can filter things out if
you need to.

Hope this helps.

Jeff Gibson
Intercept Solutions - Sybase SQL Anywhere OEM Partner
Nashville, TN

"Manmaria" <officialinquiry@gmail.com> wrote in message
news:48caa5e1$1@forums-1-dub...
> How do I find the list of non system triggers?
> TIA
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp


Manmaria Posted on 2008-09-12 18:27:48.0Z
From: "Manmaria" <officialinquiry@gmail.com>
Newsgroups: ianywhere.public.general
Organization: 159.140.254.10
References: <48caa5e1$1@forums-1-dub>
X-Newsreader: AspNNTP 1.50 (JodoHost)
Subject: Re: List of Triggers
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48cab4a4$1@forums-1-dub>
Date: 12 Sep 2008 11:27:48 -0700
X-Trace: forums-1-dub 1221244068 10.22.241.152 (12 Sep 2008 11:27:48 -0700)
X-Original-Trace: 12 Sep 2008 11:27:48 -0700, vip152.sybase.com
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7085
Article PK: 5307

Found it.

select

distinct b.Name

from syscomments A

JOIN sysobjects B ON

A.id = B.id

Where type = 'TR'