Tables [dbo].[Instruction]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created1:22:13 AM Thursday, September 10, 2009
Last Modified1:22:13 AM Thursday, September 10, 2009
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK__Instruction__7F2BE32F: ididvarchar(255)255
No
asUservarchar(255)255
Yes
counterint4
Yes
instructionHashint4
Yes
operationvarchar(255)255
Yes
parentTransactionContextIdvarchar(255)255
Yes
rpathvarchar(255)255
Yes
serializedKeytextmax
Yes
serializedSOtextmax
Yes
timebigint8
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__Instruction__7F2BE32F: idPK__Instruction__7F2BE32Fid
Yes
SQL Script
CREATE TABLE [dbo].[Instruction]
(
[id] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[asUser] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[counter] [int] NULL,
[instructionHash] [int] NULL,
[operation] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[parentTransactionContextId] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rpath] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[serializedKey] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[serializedSO] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[time] [bigint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Instruction] ADD CONSTRAINT [PK__Instruction__7F2BE32F] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
Uses