Tables [dbo].[Disclaimers]
(local) > SupportBridge > Tables > dbo.Disclaimers
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key pk_disclaimers: disclaimerIDdisclaimerIDint4
No
1 - 1
divisionIDint4
No
disclaimerNamenvarchar(30)60
No
disclaimerTextntextmax
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_disclaimers: disclaimerIDpk_disclaimersdisclaimerID
Yes
SQL Script
CREATE TABLE [dbo].[Disclaimers]
(
[disclaimerID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[disclaimerName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[disclaimerText] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Disclaimers] ADD CONSTRAINT [pk_disclaimers] PRIMARY KEY CLUSTERED ([disclaimerID]) ON [PRIMARY]
GO
Uses
Used By
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved