Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Unhappy Unanswered: query for nut null constrain

    How can I write a query to get all the table_name,column_name which has not null constraint from sysmaster table. Thanks in advance

  2. #2
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    Hi,

    Here is the SQL:

    select tabname, colname
    from syscolumns c, systables s
    where c.tabid=s.tabid and
    s.tabid >99 and coltype>=256 ;

    Regards,
    Shriyan

Posting Permissions

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