Table - dbo.NON_EMPLOYEE_A_RACE

Properties

Property	Value
Name	NON_EMPLOYEE_A_RACE_CODE
Schema	dbo
Row Count	849
Data Size	32 KB
Index Size	40 KB
Create Date	11/5/2012 9:36 AM
Description

Columns

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
cnxarraycolumn	smallint(5, 0)	False	False	False
ISN_NON_EMPLOYEE_A	int(10, 0)	False	False	False
RACE_CODE	varchar(1)	True	False	False
RACE_CODE_COUNT	smallint(5, 0)	False	False	False
RowUpdatedOn	datetime2(27, 7)	False	False	False

Triggers

Name

Insert

Update

Delete

Instead

Indexes

Name	Clustered	Columns
U1H22GR18RT207	False	ISN_NON_EMPLOYEE_A, cnxarraycolumn

Foreign Key Constraints

Name

Columns

Referenced Table

Referenced Columns

Checked

Check Constraints

Name

Text

Checked

Parent Dependencies (objects that dbo.NON_EMPLOYEE_A_RACE_CODE depends on)

Name

Type

Child Dependencies (objects that depend on dbo.NON_EMPLOYEE_A_RACE_CODE)

Name

Type

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[NON_EMPLOYEE_A_RACE_CODE] Script Date: 03/09/2017 16:45:45 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[NON_EMPLOYEE_A_RACE_CODE](
    [ISN_NON_EMPLOYEE_A] [int] NOT NULL,
    [RACE_CODE_COUNT] [smallint] NOT NULL,
    [RACE_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)

Sample Data

cnxarraycolumn	ISN_NON_EMPLOYEE_A	RACE_CODE	RACE_CODE_COUNT	RowUpdatedOn
0	201	X	1	2017-02-06T11:30:35.004-05:00
0	804	X	1	2017-02-06T11:30:35.02-05:00
0	45	W	1	2017-02-06T11:30:35.004-05:00
0	232	X	1	2017-02-06T11:30:35.004-05:00
0	786	X	1	2017-02-06T11:30:35.02-05:00
0	393	X	1	2017-02-06T11:30:35.004-05:00
0	43	W	1	2017-02-06T11:30:35.004-05:00
0	42	W	1	2017-02-06T11:30:35.004-05:00
0	95	X	1	2017-02-06T11:30:35.004-05:00
0	384	X	1	2017-02-06T11:30:35.004-05:00