|
![]() |
Property | Value |
Name | ST_CLASS_SCHD_A_CLS_SCHD_DAY |
Schema | dbo |
Row Count | 563352 |
Data Size | 11400 KB |
Index Size | 9544 KB |
Create Date | 8/15/2012 12:45 PM |
Description |
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
![]() |
![]() |
CLS_SCHD_DAY |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
CLS_SCHD_DAY_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
![]() |
![]() |
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
![]() |
![]() |
ISN_ST_CLASS_SCHD_A |
int(10, 0) |
False |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_ST_CLASS_SCHD_A, cnxarraycolumn |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
Name | Type |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[ST_CLASS_SCHD_A_CLS_SCHD_DAY] Script Date: 03/09/2017 16:46:00 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_CLASS_SCHD_A_CLS_SCHD_DAY]( [ISN_ST_CLASS_SCHD_A] [int] NOT NULL, [CLS_SCHD_DAY_COUNT] [smallint] NOT NULL, [CLS_SCHD_DAY] [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 ) |
CLS_SCHD_DAY | CLS_SCHD_DAY_COUNT | cnxarraycolumn | ISN_ST_CLASS_SCHD_A | RowUpdatedOn |
T | 3 | 0 | 129892 | 2017-02-06T10:38:13.784-05:00 |
T | 1 | 0 | 33538 | 2017-02-06T10:38:06.202-05:00 |
T | 2 | 0 | 193516 | 2017-02-06T10:38:18.979-05:00 |
R | 2 | 1 | 208345 | 2017-02-06T10:38:20.242-05:00 |
N | 6 | 1 | 193055 | 2017-02-06T10:38:18.932-05:00 |
M | 2 | 0 | 37140 | 2017-02-06T10:38:06.561-05:00 |
T | 2 | 0 | 77381 | 2017-02-06T10:38:09.697-05:00 |
R | 1 | 0 | 251566 | 2017-02-06T10:38:24.002-05:00 |
R | 4 | 3 | 61505 | 2017-02-06T10:38:08.464-05:00 |
W | 4 | 2 | 256021 | 2017-02-06T10:38:24.423-05:00 |
Powered by BI Documenter |