Post reply

Default Value

  • June 6, 2007 at 11:27 am

    #103372

    I need to know if a column has a Default Value for each column on every single table on my database, How can do this?

    Thanks for your suggestions.

  • June 6, 2007 at 11:57 am

    #711200

    You need to know what will be the default for each datatype.  But the real question is why do you need to do this?

  • June 6, 2007 at 12:58 pm

    #711213

    The main goal is to compare two databases and indetify differences between columns, datatypes, collation and default values.

    I'm using Sql compare and Kentico Software but in both of them default value is not include.

     

    Thanks for any advice.

  • June 6, 2007 at 1:19 pm

    #711221

    I c, I misread the question.

     

    This will get you started in the right direction :

    SELECT * FROM dbo.SysColumns C INNER JOIN dbo.SysObjects O ON C.cDefault = O.id

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply