Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    47

    Unanswered: system tables and crows feet

    I am running DB2 v.8 on AIX
    1. What sql can I write to query the system tables to return an alphabetic listing of column names within a table ?
    example:
    select * from system_table where col_name like 'TRAN%' and
    table_name like 'TRAN_TAB%'


    2. In an ER diagram..the crows feet touching a table indicate that table holds the primary or foreign key???

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: system tables and crows feet

    Originally posted by ksexton
    I am running DB2 v.8 on AIX
    1. What sql can I write to query the system tables to return an alphabetic listing of column names within a table ?
    example:
    select * from system_table where col_name like 'TRAN%' and
    table_name like 'TRAN_TAB%'


    2. In an ER diagram..the crows feet touching a table indicate that table holds the primary or foreign key???
    1. SELECT * FROM SYSCAT.COLUMNS WHERE COLNAME ... AND TABNAME ...

    2. I think in some notations the "crow foot" thing shows the "...-to-many" part of the relationship. It might be represented by a foreign key, yes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •