[dbo].[ScriptExecStatus]

(local) > SupportBridge > Tables > dbo.ScriptExecStatus

Properties
Columns
Indexes
Foreign Keys
SQL Script
Uses

Property	Value
Row Count	119
Created	12:44:46 PM Thursday, October 04, 2007
Last Modified	12:44:46 PM Thursday, October 04, 2007

Columns

Name	Data Type	Max Length (Bytes)
eventID	decimal(28,0)	13
scriptID	int	4
executedStatus	int	4

Indexes

	Name	Columns	Unique
	PK__ScriptExecStatus__0EF836A4	eventID

Foreign Keys

Name	Columns
FK__ScriptExe__event__0FEC5ADD	eventID->[dbo].[EventHistory].[eventID]

SQL Script

CREATE TABLE [dbo].[ScriptExecStatus]
(
[eventID] [decimal] (28, 0) NOT NULL,
[scriptID] [int] NOT NULL,
[executedStatus] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScriptExecStatus] ADD CONSTRAINT [PK__ScriptExecStatus__0EF836A4] PRIMARY KEY CLUSTERED ([eventID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScriptExecStatus] ADD CONSTRAINT [FK__ScriptExe__event__0FEC5ADD] FOREIGN KEY ([eventID]) REFERENCES [dbo].[EventHistory] ([eventID])
GO

Uses

[dbo].[EventHistory]
dbo