Tables [dbo].[bp_standard_category]
Properties
PropertyValue
Row Count0
Created12:30:47 PM Sunday, December 05, 2010
Last Modified12:33:24 PM Sunday, December 05, 2010
Columns
NameData TypeCollationMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKbp_standard_category: bp_standard_category_idbp_standard_category_idbinary(16)16
No
namenvarchar(255)SQL_Latin1_General_CP1_CS_AS510
No
statementntextSQL_Latin1_General_CP1_CI_ASmax
Yes
numbernvarchar(50)SQL_Latin1_General_CP1_CS_AS100
No
Foreign Keys $bp_st_r00001bd100000000: [dbo].[configuration_standard_set].config_standard_set_idconfig_standard_set_idbinary(16)16
No
creation_usernvarchar(64)SQL_Latin1_General_CP1_CS_AS128
No
creation_dateint4
No
last_update_usernvarchar(64)SQL_Latin1_General_CP1_CS_AS128
No
last_update_dateint4
No
version_numberint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKbp_standard_category: bp_standard_category_idXPKbp_standard_categorybp_standard_category_id
Yes
Foreign Keys Foreign Keys
NameColumns
$bp_st_r00001bd100000000config_standard_set_id->[dbo].[configuration_standard_set].[config_standard_set_id]
SQL Script
CREATE TABLE [dbo].[bp_standard_category]
(
[bp_standard_category_id] [binary] (16) NOT NULL,
[name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[statement] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[number] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[config_standard_set_id] [binary] (16) NOT NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[creation_date] [int] NOT NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[last_update_date] [int] NOT NULL,
[version_number] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[bp_standard_category] ADD CONSTRAINT [XPKbp_standard_category] PRIMARY KEY CLUSTERED ([bp_standard_category_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[bp_standard_category] ADD CONSTRAINT [$bp_st_r00001bd100000000] FOREIGN KEY ([config_standard_set_id]) REFERENCES [dbo].[configuration_standard_set] ([config_standard_set_id])
GO
Uses
Used By