Tables [dbo].[al_link_sl_own_sl_dis]
Properties
PropertyValue
HeapYes
Row Count16
Created10:33:05 PM Thursday, February 10, 2011
Last Modified10:34:19 PM Thursday, February 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Foreign Keys AL_LINK_SL_OWN_SL_DIS_ARG_FK1: [dbo].[arg_sl_own_match_fields].sl_own_idIndexes al_link_sl_own_sl_dis_uk1: sl_own_id\sl_dis_idsl_own_idsmallint2
No
Foreign Keys AL_LINK_SL_OWN_SL_DIS_ARG_FK2: [dbo].[arg_sl_dis_match_fields].sl_dis_idIndexes al_link_sl_own_sl_dis_uk1: sl_own_id\sl_dis_idsl_dis_idsmallint2
No
Indexes Indexes
NameColumnsUnique
al_link_sl_own_sl_dis_uk1sl_own_id, sl_dis_id
Yes
Foreign Keys Foreign Keys
NameColumns
AL_LINK_SL_OWN_SL_DIS_ARG_FK1sl_own_id->[dbo].[arg_sl_own_match_fields].[id]
AL_LINK_SL_OWN_SL_DIS_ARG_FK2sl_dis_id->[dbo].[arg_sl_dis_match_fields].[id]
SQL Script
CREATE TABLE [dbo].[al_link_sl_own_sl_dis]
(
[sl_own_id] [smallint] NOT NULL,
[sl_dis_id] [smallint] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_link_sl_own_sl_dis] ADD CONSTRAINT [al_link_sl_own_sl_dis_uk1] UNIQUE NONCLUSTERED ([sl_own_id], [sl_dis_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_link_sl_own_sl_dis] ADD CONSTRAINT [AL_LINK_SL_OWN_SL_DIS_ARG_FK1] FOREIGN KEY ([sl_own_id]) REFERENCES [dbo].[arg_sl_own_match_fields] ([id])
GO
ALTER TABLE [dbo].[al_link_sl_own_sl_dis] ADD CONSTRAINT [AL_LINK_SL_OWN_SL_DIS_ARG_FK2] FOREIGN KEY ([sl_dis_id]) REFERENCES [dbo].[arg_sl_dis_match_fields] ([id])
GO
Uses