Post reply

column defaults written to a table script

  • June 1, 2007 at 12:33 pm

    #173958

    Using SQL Server 2005 --

    developer created database defaults, created table and set column defaults equal to the database defaults.

    When she scripted the table using the table pop-up menu (Script table as ... Create table), the constraints were not included in the script.

    Going back to the table design and replacing the the database default with direct defaults, the same scripting action does include the constraints.

    Anybody out there know why that may be?

  • June 4, 2007 at 10:49 am

    #710666

    From Management Studio go to Tools / Options Select Scripting and then Table and Views scripting Options. Set Script Defaults to True.

  • June 4, 2007 at 10:59 am

    #710668

    Thanks, Camilo, for the answer. Unfortunately, the option is already set to True.  Got any other ideas?

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

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