Skip to content

Tag Archives: Example

What BLOB tables do I have?

Tuesday, February 23, 2010

The following is SQL code was published in the #ingres IRC channel on freenode in response to a question about the best method to determine which iietab_xx_yy table belongs to which table: select r1.relid as base_table, c.attname as column_name, r2.relid as extend_table from iirelation r1,iirelation r2,iiattribute c,iiextended_relation e where r1.reltid=e.etab_base and r2.reltid=e.etab_extension and r1.reltid=c.attrelid and [...]

  • Share/Bookmark
Filed in ingres, sql | Also tagged , , , | View Comments