/****** Object:  Table [dbo].[ng_check_indexes_output]    Script Date: 1/19/2015 5:03:44 PM ******/
IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ng_check_indexes_output]') AND type in (N'U'))
DROP TABLE [dbo].[ng_check_indexes_output]
GO

/****** Object:  Table [dbo].[ng_check_indexes_output]    Script Date: 1/19/2015 5:03:44 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ng_check_indexes_output](
	[output_type] [varchar](3) NOT NULL,
	[table_name] [sysname] NOT NULL,
	[index_name] [sysname] NOT NULL,
	[index_columns] [nvarchar](1000) NULL,
	[primary_ind] [char](1) NULL,
	[clustered_ind] [char](1) NULL,
	[unique_ind] [char](1) NULL,
	[rec_index_columns] [nvarchar](1000) NULL,
	[rec_primary_ind] [char](1) NULL,
	[rec_clustered_ind] [char](1) NULL,
	[rec_unique_ind] [char](1) NULL,
	[fulltext_index_ind] [char](1) NOT NULL CONSTRAINT [DFng_check_indexes_output_fulltext_index_ind]  DEFAULT ('N'),
	[iot_table_ind] [char](1) NOT NULL CONSTRAINT [DFng_check_indexes_output_iot_table_ind]  DEFAULT ('N'),
	[functionbase_ind] [char](1) NOT NULL CONSTRAINT [DFng_check_indexes_output_functionbase_ind]  DEFAULT ('N'),
	[sql_text] [varchar](1000) NULL,
	[error_msg] [varchar](1000) NULL,
	[create_timestamp] [datetime] NOT NULL CONSTRAINT [DFng_check_indexes_output_create_timestamp]  DEFAULT (getdate()),
	[rec_included_columns] [nvarchar](max) NULL,
	[included_columns] [nvarchar](max) NULL
) ON [NEXTGEN_CORE] TEXTIMAGE_ON [NEXTGEN_CORE]

GO

SET ANSI_PADDING OFF
GO