Using the "Long Format Leading Comma" format and it is not formatting my IDENTITY column correctly. Only the IDENTITY column is the main focus, it break the IDENTITY column up instead of leaving it on the same line.
Replicated this issue in Toad 5.7. Toad 5.6 was still formatting this correctly.
,
Please see the example below:
Example for part of the code before formatting:
CREATE TABLE [APP].[LuCreditCIMReasons] (
[CreditCIMReasonID] smallint IDENTITY(1, 1) NOT NULL,
[CreditCIMReasonValue] varchar(50) NOT NULL,
[CreditCIMSourceID] smallint NULL,
[CreditCIMTypeID] smallint NULL,
[CreateUserId] int NULL,
[CreateDate] datetime NULL,
[LastUpdateUserId] int NULL,
[LastUpdateDate] datetime NULL,
Format with Toad 5.6:
CREATE TABLE [APP].[LuCreditCIMReasons](
[CreditCIMReasonID] smallint IDENTITY (1, 1) NOT NULL
,[CreditCIMReasonValue] varchar(50) NOT NULL
,[CreditCIMSourceID] smallint NULL
,[CreditCIMTypeID] smallint NULL
,[CreateUserId] int NULL
,[CreateDate] datetime NULL
,[LastUpdateUserId] int NULL
,[LastUpdateDate] datetime NULL
,CONSTRAINT [PK__LuCredit__B4802FF14589517F] PRIMARY KEY
CLUSTERED
([CreditCIMReasonID] ASC)
,
Format with Toad 5.7:
CREATE TABLE [APP].[LuCreditCIMReasons](
[CreditCIMReasonID] smallint
IDENTITY (
1,
1)
NOT NULL
,[CreditCIMReasonValue] varchar(50) NOT NULL
,[CreditCIMSourceID] smallint NULL
,[CreditCIMTypeID] smallint NULL
,[CreateUserId] int NULL
,[CreateDate] datetime NULL
,[LastUpdateUserId] int NULL
,[LastUpdateDate] datetime NULL
,CONSTRAI
WORKAROUND:
None
RESOLUTION:
Waiting for fix in future release of Toad for SQL Server.
