[dbo].[C2OAgenda]

(local) > itpam > Tables > dbo.C2OAgenda

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Row Count	0
Created	11:42:02 AM Friday, March 26, 2010
Last Modified	11:42:02 AM Friday, March 26, 2010

Columns

Name	Data Type	Max Length (Bytes)
AgendaState	tinyint	1
ObjectID	int	4
ValidFromDate	datetime	8
ActivationDate	datetime	8
ValidToDate	datetime	8

Indexes

	Name	Columns	Unique
	PK__C2OAgenda__33D4B598	ObjectID

SQL Script

CREATE TABLE [dbo].[C2OAgenda]
(
[AgendaState] [tinyint] NULL,
[ObjectID] [int] NOT NULL,
[ValidFromDate] [datetime] NULL,
[ActivationDate] [datetime] NULL,
[ValidToDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C2OAgenda] ADD CONSTRAINT [PK__C2OAgenda__33D4B598] PRIMARY KEY CLUSTERED ([ObjectID]) ON [PRIMARY]
GO

Uses