Results 1 to 3 of 3

Thread: systemobject

  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unanswered: systemobject

    hi

    is there any system view/table in sybase similar to a view like "information_schema.columns" (in ms sql sever)?

    the problem is .....

    i want to know the column names with table name in all the tables.
    for that i tried to create a view with fields--'column_name','table_name'.


    plz help in this regard.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    select a.name "Table Name",b.name "Column Name" from sysobjects a, syscolumns b where a.id = b.id and a.type in ("U", "V")

  3. #3
    Join Date
    Nov 2003
    Posts
    3

    thanx

    Originally posted by willy_and_the_ci
    select a.name "Table Name",b.name "Column Name" from sysobjects a, syscolumns b where a.id = b.id and a.type in ("U", "V")
    thanq very much

Posting Permissions

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