[dbo].[TIMERS]

[dbo].[TIMERS]

Properties
Columns
Indexes
SQL Script
Uses

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

Columns

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key TIMERS_PK: TIMERID\TARGETID$	TIMERID	varchar(80)	80
$Cluster Primary Key TIMERS_PK: TIMERID\TARGETID$	TARGETID	varchar(80)	80
	INITIALDATE	datetime	8
	TIMERINTERVAL	bigint	8
	INSTANCEPK	image	max
	INFO	image	max

Indexes

	Name	Columns	Unique
$Cluster Primary Key TIMERS_PK: TIMERID\TARGETID$	TIMERS_PK	TIMERID, TARGETID

SQL Script

CREATE TABLE [dbo].[TIMERS]
(
[TIMERID] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TARGETID] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[INITIALDATE] [datetime] NOT NULL,
[TIMERINTERVAL] [bigint] NULL,
[INSTANCEPK] [image] NULL,
[INFO] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[TIMERS] ADD CONSTRAINT [TIMERS_PK] PRIMARY KEY CLUSTERED ([TIMERID], [TARGETID]) ON [PRIMARY]
GO

Uses