Tables [dbo].[RPQQ]
(local) > CAAMDB_EXAMPLE > Tables > dbo.RPQQ
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count2
Created3:44:41 PM Friday, June 13, 2003
Last Modified3:44:41 PM Friday, June 13, 2003
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key RPQQ_PK: QQIDQQIDint4
No
IDXint4
Yes
TITLEvarchar(255)255
Yes
SQLTXTvarchar(255)255
Yes
Indexes Indexes
NameColumnsUnique
Primary Key RPQQ_PK: QQIDRPQQ_PKQQID
Yes
SQL Script
CREATE TABLE [dbo].[RPQQ]
(
[QQID] [int] NOT NULL,
[IDX] [int] NULL,
[TITLE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SQLTXT] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPQQ] ADD CONSTRAINT [RPQQ_PK] PRIMARY KEY NONCLUSTERED ([QQID]) ON [PRIMARY]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved