|
![]() |
Property | Value |
Name | ST_INTERNAL_ARTICULATION_A_COURSE_INFO |
Schema | dbo |
Row Count | 165 |
Data Size | 8 KB |
Index Size | 24 KB |
Create Date | 8/15/2012 1:36 PM |
Description |
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
![]() |
![]() |
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
![]() |
![]() |
COURSE_INFO_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
![]() |
![]() |
CRNT_CRS |
varchar(10) |
True |
False |
False |
|||
![]() |
![]() |
GRADE |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
ISN_ST_INTERNAL_ARTICULATION_A |
int(10, 0) |
False |
False |
False |
|||
![]() |
![]() |
LIC_CERT_IND |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_ST_INTERNAL_ARTICULATION_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_INTERNAL_ARTICULATION_A_COURSE_INFO] Script Date: 03/09/2017 16:46:10 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_INTERNAL_ARTICULATION_A_COURSE_INFO]( [ISN_ST_INTERNAL_ARTICULATION_A] [int] NOT NULL, [COURSE_INFO_COUNT] [smallint] NOT NULL, [CRNT_CRS] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [GRADE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LIC_CERT_IND] [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 ) |
cnxarraycolumn | COURSE_INFO_COUNT | CRNT_CRS | GRADE | ISN_ST_INTERNAL_ARTICULATION_A | LIC_CERT_IND | RowUpdatedOn |
0 | 3 | CHD1220 | P | 36 | 2017-02-06T11:34:25.839-05:00 | |
2 | 3 | EEC2734 | P | 16 | 2017-02-06T11:34:25.839-05:00 | |
0 | 1 | CJK1933 | S | 25 | 2017-02-06T11:34:25.839-05:00 | |
2 | 9 | CJD1731C | P | 13 | 2017-02-06T11:34:25.839-05:00 | |
1 | 8 | CJD1742 | P | 7 | 2017-02-06T11:34:25.839-05:00 | |
2 | 3 | EEC2734 | P | 15 | 2017-02-06T11:34:25.839-05:00 | |
6 | 8 | CJD1773 | P | 9 | 2017-02-06T11:34:25.839-05:00 | |
0 | 1 | CJD1933 | S | 44 | 2017-02-06T11:34:25.839-05:00 | |
6 | 9 | CJD1762 | P | 2 | 2017-02-06T11:34:25.839-05:00 | |
0 | 3 | CHD1220 | P | 20 | 2017-02-06T11:34:25.839-05:00 |
Powered by BI Documenter |