Tables [dbo].[CommsTemp]
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__CommsTemp__1C1D2798: dataIDdataIDdecimal(18,0)9
No
1 - 1
datantextmax
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__CommsTemp__1C1D2798: dataIDPK__CommsTemp__1C1D2798dataID
Yes
SQL Script
CREATE TABLE [dbo].[CommsTemp]
(
[dataID] [decimal] (18, 0) NOT NULL IDENTITY(1, 1),
[data] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[CommsTemp] ADD CONSTRAINT [PK__CommsTemp__1C1D2798] PRIMARY KEY CLUSTERED ([dataID]) ON [PRIMARY]
GO
Uses