-- Table: dbo.ObjectsByDatabase
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[ObjectsByDatabase] (
	[DatabaseName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ObjectType] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[CountDate] [int] NOT NULL ,
	[ObjectCount] [int] NULL ,
	CONSTRAINT [pk_ObjectsByDatabase__DatabaseName__ObjectType__CountDate] 
        PRIMARY KEY  CLUSTERED 
	(
		[DatabaseName],
		[ObjectType],
		[CountDate]
	)  ON [PRIMARY] ,
	CONSTRAINT [uk_ObjectsByDatabase__CountDate__DatabaseNAme__ObjectType] 
        UNIQUE  NONCLUSTERED 
	(
		[CountDate],
		[DatabaseName],
		[ObjectType]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO