Results 1 to 3 of 3

Thread: Desc function

  1. #1
    Join Date
    Aug 2004
    Buenos Aires, Argentina

    Unanswered: Desc function

    Hi guys, I'm a newbie to Sybase - always worked with Oracle or SQL Server.
    I don't have the description of the tables I need to work with. So just I need something like the "desc" command in Oracle - to see the column names, types, etc for a specific table.
    I believe I may need to run a query with the object_id funtion against the sys tables, but I cannot seem to get it to work.
    Could you please help me out? Thanks in advance!

  2. #2
    Join Date
    Aug 2008

    Does sp_help suffice?

    sp_help <tablename>

    Regards, ...

  3. #3
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3
    SELECT AS table_name, as column_name, as type_name, c.length, c.prec, c.scale
    FROM sysobjects t, syscolumns c, systypes dt
    WHERE t.type = 'U'
    AND =
    AND c.type = dt.type
    AND = YourTableName

Posting Permissions

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