Here's the Create for TrackFragmentation table

USE [scheduler]
GO
/****** Object: Table [dbo].[TrackFragmentation] Script Date: 04/01/2008 19:06:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TrackFragmentation](
[DBName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TableName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IndexName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IndexType] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DataStoreType] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[partition_number] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[current_density_percentage] [float] NULL,
[current_fragmentation_percentage] [float] NULL,
[MBUsed] [numeric](29, 7) NULL,
[Rows] [int] NULL,
[object_id] [int] NULL,
[index_id] [int] NULL,
[RunOnline] [bit] NULL CONSTRAINT [DF_TrackFragmentation_RunOnline] DEFAULT ((1)),
[DateCreated] [datetime] NULL,
[RunID] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Comments :

0 comments to “Here's the Create for TrackFragmentation table”