Tables [dbo].[XmlOrderLink]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created4:57:10 PM Thursday, September 7, 2006
Last Modified7:32:36 PM Wednesday, February 28, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDescription
Cluster Primary Key PK_XmlOrderLink: XmlOrderLinkIDXmlOrderLinkIDint4
No
1 - 1The primary key.
Foreign Keys FK_XmlOrderLink_Orders: [dbo].[Orders].OrderFIDIndexes IX_XmlOrderLink_Order_System: OrderFID\XmlSystemFIDIndexes IX_Unique_XmlOrderLink_System_Order: XmlSystemFID\OrderFIDOrderFIDint4
No
Foreign key to an order.
Foreign Keys FK_XmlOrderLink_XmlSystem: [dbo].[XmlSystem].XmlSystemFIDIndexes IX_XmlOrderLink_Order_System: OrderFID\XmlSystemFIDIndexes IX_XmlOrderLink_System_ExternalKey: XmlSystemFID\ExternalKeyIndexes IX_Unique_XmlOrderLink_System_Order: XmlSystemFID\OrderFIDXmlSystemFIDint4
No
Foreign key to an xml system.
Indexes IX_XmlOrderLink_System_ExternalKey: XmlSystemFID\ExternalKeyExternalKeyvarchar(60)60
No
The primary key for the xml system.
SecondaryExternalKeyvarchar(60)60
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_XmlOrderLink: XmlOrderLinkIDPK_XmlOrderLinkXmlOrderLinkID
Yes
80
IX_Unique_XmlOrderLink_System_OrderXmlSystemFID, OrderFID
Yes
IX_XmlOrderLink_Order_SystemOrderFID, XmlSystemFID
IX_XmlOrderLink_System_ExternalKeyXmlSystemFID, ExternalKey
Foreign Keys Foreign Keys
NameColumns
FK_XmlOrderLink_OrdersOrderFID->[dbo].[Orders].[PriKey]
FK_XmlOrderLink_XmlSystemXmlSystemFID->[dbo].[XmlSystem].[XmlSystemID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[XmlOrderLink]
(
[XmlOrderLinkID] [int] NOT NULL IDENTITY(1, 1),
[OrderFID] [int] NOT NULL,
[XmlSystemFID] [int] NOT NULL,
[ExternalKey] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SecondaryExternalKey] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlOrderLink] ADD CONSTRAINT [PK_XmlOrderLink] PRIMARY KEY CLUSTERED  ([XmlOrderLinkID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlOrderLink] ADD CONSTRAINT [IX_Unique_XmlOrderLink_System_Order] UNIQUE NONCLUSTERED  ([XmlSystemFID], [OrderFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XmlOrderLink_Order_System] ON [dbo].[XmlOrderLink] ([OrderFID], [XmlSystemFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XmlOrderLink_System_ExternalKey] ON [dbo].[XmlOrderLink] ([XmlSystemFID], [ExternalKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlOrderLink] ADD CONSTRAINT [FK_XmlOrderLink_Orders] FOREIGN KEY ([OrderFID]) REFERENCES [dbo].[Orders] ([PriKey])
GO
ALTER TABLE [dbo].[XmlOrderLink] ADD CONSTRAINT [FK_XmlOrderLink_XmlSystem] FOREIGN KEY ([XmlSystemFID]) REFERENCES [dbo].[XmlSystem] ([XmlSystemID])
GO
GRANT SELECT ON  [dbo].[XmlOrderLink] TO [MssExec]
GRANT INSERT ON  [dbo].[XmlOrderLink] TO [MssExec]
GRANT DELETE ON  [dbo].[XmlOrderLink] TO [MssExec]
GRANT UPDATE ON  [dbo].[XmlOrderLink] TO [MssExec]
GO
EXEC sp_addextendedproperty N'MS_Description', N'The primary key for the xml system.', 'SCHEMA', N'dbo', 'TABLE', N'XmlOrderLink', 'COLUMN', N'ExternalKey'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key to an order.', 'SCHEMA', N'dbo', 'TABLE', N'XmlOrderLink', 'COLUMN', N'OrderFID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The primary key.', 'SCHEMA', N'dbo', 'TABLE', N'XmlOrderLink', 'COLUMN', N'XmlOrderLinkID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key to an xml system.', 'SCHEMA', N'dbo', 'TABLE', N'XmlOrderLink', 'COLUMN', N'XmlSystemFID'
GO
Uses
Used By