dbo.GS_SSNVTrackerResults Table

Properties

Creation Date	9/25/2015 3:11 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	0
Data Space Used	0.00 KB
Index Space Used	0.00 KB

Columns

Column Name	Datatype	Length
SSNVTrackerResults_ID	int	4
EmployeeID	varchar	50
ErrorCode	varchar	20
ErrorString	varchar	250
Modified	datetime	4

Indexes

Index	Description	Primary	Unique
PK__GS_SSNVT__99F5F91EC803779C
UQ__GS_SSNVT__7AD04FF05096AE34

Objects that depend on dbo.GS_SSNVTrackerResults

	Database Object	Object Type	Description	Dep Level
	dbo.GS_RefreshSSNVTrackerResults	Stored Procedure		1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[GS_SSNVTrackerResults](
	[SSNVTrackerResults_ID] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeID] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ErrorCode] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ErrorString] [varchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Modified] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[SSNVTrackerResults_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
	[EmployeeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Related Objects

dbo Schema
SQL Objects Database