SELECT "OBJID","OWNER","OWNERID","TNAME","TYPE","CNAME","CNO","CONDITION","CONDLENGTH","ENABLED","DEFER","SQLVER","INAME","IDXSYSGEND"
FROM sys.exu8con
WHERE userenv('SCHEMAID') = ownerid
SELECT "OBJID"
, "OWNER"
, "OWNERID"
, "TNAME"
, "TYPE"
, "CNAME"
, "CNO"
, "CONDITION"
, "CONDLENGTH"
, "ENABLED"
, "DEFER"
, "SQLVER"
, "INAME"
, "IDXSYSGEND"
FROM SYS.EXU8CON
WHERE USERENV('SCHEMAID') = OWNERID
|
|
|