
/****** Object:  Table [dbo].[ng_indexes]    Script Date: 1/20/2015 9:11:31 AM ******/
IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ng_indexes]') AND type in (N'U'))
DROP TABLE [dbo].[ng_indexes]
GO

/****** Object:  Table [dbo].[ng_indexes]    Script Date: 1/20/2015 9:11:31 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ng_indexes](
	[table_name] [varchar](30) NOT NULL,
	[index_name] [varchar](36) NOT NULL,
	[index_columns] [varchar](860) NOT NULL,
	[group_name] [varchar](256) NULL,
	[primary_ind] [char](1) NOT NULL CONSTRAINT [DFng_indexes_primary_ind]  DEFAULT ('N'),
	[clustered_ind] [char](1) NOT NULL CONSTRAINT [DFng_indexes_clustered_ind]  DEFAULT ('N'),
	[unique_ind] [char](1) NOT NULL CONSTRAINT [DFng_indexes_unique_ind]  DEFAULT ('N'),
	[fill_factor] [smallint] NULL,
	[padindex_ind] [char](1) NOT NULL CONSTRAINT [DFng_indexes_padindex_ind]  DEFAULT ('N'),
	[override_ind] [char](1) NOT NULL CONSTRAINT [DFng_indexes_override_ind]  DEFAULT ('N'),
	[override_notes] [varchar](1000) NULL,
	[updated_version] [varchar](12) NULL,
	[ng_system_ind] [char](1) NOT NULL CONSTRAINT [DFng_indexes_ng_system_ind]  DEFAULT ('N'),
	[release_date] [datetime] NOT NULL CONSTRAINT [DFng_indexes_release_date]  DEFAULT (getdate()),
	[load_date] [datetime] NOT NULL CONSTRAINT [DFng_indexes_load_date]  DEFAULT (getdate()),
	[row_timestamp] [timestamp] NOT NULL,
	[fulltext_index_ind] [char](1) NOT NULL CONSTRAINT [DFng_indexes_fulltext_index_ind]  DEFAULT ('N'),
	[iot_table_ind] [char](1) NOT NULL CONSTRAINT [DFng_indexes_iot_table_ind]  DEFAULT ('N'),
	[functionbase_ind] [char](1) NOT NULL CONSTRAINT [DFng_indexes_functionbase_ind]  DEFAULT ('N'),
	[included_columns] [varchar](max) NULL,
 CONSTRAINT [pk_ng_indexes] PRIMARY KEY NONCLUSTERED 
(
	[index_name] ASC,
	[table_name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [NEXTGEN_INDEX_1]
) ON [NEXTGEN_CORE] TEXTIMAGE_ON [NEXTGEN_CORE]

GO

SET ANSI_PADDING OFF
GO


