[dbo].[crltable]

[dbo].[crltable]

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	12:30:52 PM Sunday, December 05, 2010
Last Modified	12:30:52 PM Sunday, December 05, 2010

Columns

Name	Data Type	Max Length (Bytes)
sernum	varchar(40)	40
dateint	varchar(50)	50
details	varchar(1000)	1000
crevclient	varchar(20)	20

Indexes

	Name	Columns	Unique
	XPKcrltable	sernum

SQL Script

CREATE TABLE [dbo].[crltable]
(
[sernum] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[dateint] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[details] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[crevclient] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[crltable] ADD CONSTRAINT [XPKcrltable] PRIMARY KEY CLUSTERED ([sernum]) ON [PRIMARY]
GO

Uses