Odd formatting, Create table with IDENTITY

tgoldstein@co.arapahoe[email protected] Posts: 71
edited November 2, 2006 5:02AM in SQL Refactor Previous Versions
Here is what I am getting with the released version when I format a create table statement that has an identity column. I would expect to have the NOT NULL and trailing comma on the same line as the rest of the column information.

[THE_DATE] [datetime] NULL,
[AUTO_KEY] [int] IDENTITY(1, 1)
[TIME_STAMP] [binary](8) NULL

Denver, CO


  • Eddie DEddie D Posts: 1,751 Rose Gold 5

    Thank you for your post.

    I have recreated your observations and tried changing a small number of options to no avail.

    I will check with our developers and get back to you.

    Best Regards
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • Hi,

    The current version of layout has a single rule for column constraints and the optional parts of a column definition: each additional constraint is placed on a single line. This is why the NOT NULL is being placed on a line separately from the IDENTITY.

    This is intended to help out with complicated column definitions, to make it easy to pick out individual constraints at a glance. I think you have a point in that it does not look ideal for simpler definitions: we will consider refining this feature in a future version.

    Andrew Hunter
    Software Developer
    Red Gate Software Ltd.
Sign In or Register to comment.