Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    38

    Unanswered: Sybase ALLOW NULLS BY DEFAULT

    Hi,

    Is there any SQL query/sys procedure available to check the option (on/off) of ALLOW NULLS BY DEFAULT of a database ?

    Smitha

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Code:
    select name, status & 8192 from sysdatabases
    Note that this information is documented in the ASE Reference Manual, in the system tables section.

    Michael

  3. #3
    Join Date
    Jul 2006
    Posts
    7
    stored procedure 'sp_helpdb' will give u complete status.

    Guru.

Posting Permissions

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