[aiowner].[ai_his

[aiowner].[ai_his_aib]

(local) > mdb > Tables > aiowner.ai_his_aib

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	16
Created	4:50:37 PM Friday, March 16, 2007
Last Modified	4:50:37 PM Friday, March 16, 2007

Columns

	Name	Data Type	Max Length (Bytes)	Allow Nulls
	hisdate	datetime	8
	aibsets	varchar(8000)	8000

Indexes

	Name	Columns	Unique
	ai_his_aib_PK	hisdate
	ai_his_aib_AK1	hisdate

SQL Script

CREATE TABLE [aiowner].[ai_his_aib]
(
[hisdate] [datetime] NOT NULL,
[aibsets] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [aiowner].[ai_his_aib] ADD CONSTRAINT [ai_his_aib_PK] PRIMARY KEY CLUSTERED ([hisdate]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_his_aib_AK1] ON [aiowner].[ai_his_aib] ([hisdate]) ON [PRIMARY]
GO

Uses

aiowner