[dbo].[ai_hwdef_createdate

Property	Value
Row Count	175
Created	11:06:57 AM Wednesday, March 07, 2007
Last Modified	11:09:29 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)	Allow Nulls	Default
	hwuuid	uniqueidentifier	16
	createdate	datetime	8		(' ')

	Name	Columns	Unique
	ai_hwdef_createdate_kpi_pk	hwuuid
	ai_hwdef_createdate_kpi_ak1	createdate

Type	Action	Owning Principal
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Select	aiadmin
Grant	Update	aiadmin
Grant	Select	aipublic

SQL Script

CREATE TABLE [dbo].[ai_hwdef_createdate_kpi]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[createdate] [datetime] NOT NULL CONSTRAINT [DF__ai_hwdef___creat__5DF76E9B] DEFAULT (' ')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_hwdef_createdate_kpi] ADD CONSTRAINT [ai_hwdef_createdate_kpi_pk] PRIMARY KEY CLUSTERED ([hwuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_createdate_kpi_ak1] ON [dbo].[ai_hwdef_createdate_kpi] ([createdate]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_hwdef_createdate_kpi] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_hwdef_createdate_kpi] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_hwdef_createdate_kpi] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_hwdef_createdate_kpi] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_hwdef_createdate_kpi] TO [aipublic]
GO