Table - dbo.ST_STDNT_A

Properties

Property	Value
Name	ST_STDNT_A_RACE
Schema	dbo
Row Count	1329584
Data Size	26752 KB
Index Size	22504 KB
Create Date	8/15/2012 2:09 PM
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_ST_STDNT_A	int(10, 0)	False	False	False
RACE	varchar(1)	True	False	False
RACE_COUNT	smallint(5, 0)	False	False	False
RowUpdatedOn	datetime2(27, 7)	False	False	False

Triggers

Name

Insert

Update

Delete

Instead

Indexes

Name	Clustered	Columns
U24YUWN3AP1EFI	False	ISN_ST_STDNT_A, cnxarraycolumn

Foreign Key Constraints

Name

Columns

Referenced Table

Referenced Columns

Checked

Check Constraints

Name

Text

Checked

Parent Dependencies (objects that dbo.ST_STDNT_A_RACE depends on)

Name	Type
dbo.uvw_StudentRace	View

Child Dependencies (objects that depend on dbo.ST_STDNT_A_RACE)

Name	Type
dbo.uvw_StudentRace	VIEW

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[ST_STDNT_A_RACE] Script Date: 03/09/2017 16:46:23 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_A_RACE](
    [ISN_ST_STDNT_A] [int] NOT NULL,
    [RACE_COUNT] [smallint] NOT NULL,
    [RACE] [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_ST_STDNT_A	RACE	RACE_COUNT	RowUpdatedOn
0	84925	W	2	2017-02-06T09:55:07.989-05:00
0	47564	W	2	2017-02-06T09:55:05.587-05:00
1	15429	X	2	2017-02-06T09:55:03.528-05:00
1	562150	X	2	2017-02-06T09:55:39.486-05:00
0	618112	W	2	2017-02-06T09:55:42.934-05:00
0	535048	B	1	2017-02-06T09:55:37.536-05:00
0	846030	B	1	2017-02-06T09:55:57.083-05:00
0	473858	W	1	2017-02-06T09:55:33.761-05:00
0	563574	W	2	2017-02-06T09:55:39.58-05:00
0	784720	X	1	2017-02-06T09:55:53.074-05:00