/****** Object:  Table [dbo].[IDX_FRAG]    Script Date: 09/30/2009 11:47:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[IDX_FRAG](
	[databaseName] [sysname] NOT NULL,
	[ObjectName] [sysname] NOT NULL,
	[indexName] [sysname] NULL,
	[partitionNumber] [int] NULL,
	[fragmentation] [float] NULL,
	[page_count] [bigint] NULL,
	[date] [datetime] NOT NULL,
	[fill_factor] [tinyint] NULL,
	[is_padded] [bit] NULL,
	[type_desc] [nvarchar](60) NULL
) ON [PRIMARY]

GO