Column names for constraints
I want to know column names used in defining constraints. e.g. in following
querry i want to
know on which columns the constraints are defined -
database ola;
select unique colname,tabname,constrtype,idxname
from syscolumns a,systables b,outer( sysconstraints c)
where a.tabid > 99
and a.tabid = b.tabid
and b.tabid = c.tabid
and colname = 'agency_code'
and tabtype != 'V'
order by 1TIA
Mukund