Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: Column null or not null

    Hi,

    In sysbase is there any system table which gives information whether a column in table is null or not null.

    In oracle this information can be got from dba_constarints column, similarly any table in sysbase which gives the information whethere a table column is null or not null.

    Thanks in advance.

    Rgds,
    Shikha

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Re: Column null or not null

    Code:
    SELECT object_name(c.id), t.allownulls 
    FROM syscolumns c INNER JOIN systypes t ON c.usertype=t.usertype

Posting Permissions

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