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

    Question Unanswered: Default object value

    Hi,
    How can I know the value of a default object in a script/store procedure?
    I need to drop all the default objects and move their values to the columns as a table constraint. I want to use table constraint (with default value) in stead of default object.
    Any ideas?
    Thanks in advance.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Do you mean you want to know what literal values are being inserted by stored procedures?

    Not sure I know what you're asking...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    Originally posted by Brett Kaiser
    Do you mean you want to know what literal values are being inserted by stored procedures?

    Not sure I know what you're asking...

    For example:

    There is a default object MyValue, created in the follwing way:
    CREATE DEFAULT MyValue AS 10

    Having the default object name (in this case 'MyValue') I want to know what is its value (in this case 10)

Posting Permissions

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