Wednesday, 20 April 2011

ASE : SQL to Find out all "Defined Rules" in ASE database

select sysobjects.name as "rule name",
object_name(syscolumns.id) as "table name",
syscolumns.name as "column name"
from sysobjects, syscolumns
where object_name(syscolumns.domain)=sysobjects.name
and sysobjects.type='R'

No comments:

Post a Comment