Tables [dbo].[RPGLOBAL]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count4
Created10:56:30 AM Wednesday, July 02, 2003
Last Modified10:56:30 AM Wednesday, July 02, 2003
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key RPGLOBAL_PK: KEYNAME\SUBNAMEKEYNAMEvarchar(64)64
No
Cluster Primary Key RPGLOBAL_PK: KEYNAME\SUBNAMESUBNAMEvarchar(64)64
No
VALUEtextmax
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key RPGLOBAL_PK: KEYNAME\SUBNAMERPGLOBAL_PKKEYNAME, SUBNAME
Yes
SQL Script
CREATE TABLE [dbo].[RPGLOBAL]
(
[KEYNAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SUBNAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VALUE] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPGLOBAL] ADD CONSTRAINT [RPGLOBAL_PK] PRIMARY KEY CLUSTERED ([KEYNAME], [SUBNAME]) ON [PRIMARY]
GO
Uses