Options

Does source control recognize Fill Factor and index padding?

satsat Posts: 9
edited September 29, 2011 2:17PM in SQL Source Control Previous Versions
Redgate source control does not seem to recognize Index's "Fill Factor and index padding" changes.

Is there any option for fill factor setting?

/*** SCRIPT to create table with index fill factor andpadding ******/

-- Columns
CREATE TABLE [dbo].[test]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[column1] [int] NULL,
[column2] [int] NULL,
[column3] [int] NULL,
[column4] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)

GO

-- Constraints and Indexes
ALTER TABLE [dbo].[test] ADD CONSTRAINT [PK_test] PRIMARY KEYCLUSTERED ([id]) WITH (FILLFACTOR=90,PAD_INDEX=ON)
GO
CREATE NONCLUSTERED INDEX [IX_test] ON [dbo].[test] ([column2]) WITH(FILLFACTOR=90, PAD_INDEX=ON)
GO
CREATE NONCLUSTERED INDEX [IX_test_1] ON [dbo].[test] ([column4]) WITH(FILLFACTOR=90)

GO


/************* SOURCE CONTROL OUTPUT ************/


-- Columns

CREATE TABLE [dbo].[test]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[column1] [int] NULL,
[column2] [int] NULL,
[column3] [int] NULL,
[column4] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
-- Constraints and Indexes

ALTER TABLE [dbo].[test] ADD CONSTRAINT [PK_test] PRIMARY KEYCLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_test] ON [dbo].[test] ([column2]) ON[PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_test_1] ON [dbo].[test] ([column4]) ON[PRIMARY]

GO

Comments

Sign In or Register to comment.