0

Can I get a query to list out parent and child table names, parent and child column names, constraints, and constraint types in a Sybase ASE DB?

Mano
  • 601
  • 10
  • 32
  • 2
    I assume you haven't looked at the underlying SQL code in sp_help, sp_helpconstraint etc - this will do what you need. You can run sp_helptext 'sp_help' in sybsystemprocs for example to get the SQL. – Rich Campbell Feb 13 '19 at 14:37
  • @RichCampbell, I am unable to get the source code of sp_help as I am blocked from accessing it. Is there an alternate to get it? – Mano Feb 22 '19 at 16:49
  • 1
    Ask your DBA to extract it for you they will have access to run the sp_helptext without any issues. – Rich Campbell Mar 04 '19 at 08:10

0 Answers0