|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | ST_EXTRNL_CRDNTL_A_TRNSCRPT_DESC |
| Schema | dbo |
| Row Count | 3513 |
| Data Size | 200 KB |
| Index Size | 120 KB |
| Create Date | 2/26/2016 9:04 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
cnxarraycolumn |
int(10, 0) |
False |
False |
False |
|||
|
|
cnxarraycolumn_2 |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_ST_EXTRNL_CRDNTL_A |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
True |
False |
False |
|||
|
|
TRNSCRPT_DESC |
varchar(50) |
True |
False |
False |
|||
|
|
TRNSCRPT_DESC_COUNT |
smallint(5, 0) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_ST_EXTRNL_CRDNTL_A, cnxarraycolumn, cnxarraycolumn_2 |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.ST_EXTRNL_CRDNTL_A_TRNSCRPT_DESC depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.ST_EXTRNL_CRDNTL_A_TRNSCRPT_DESC)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[ST_EXTRNL_CRDNTL_A_TRNSCRPT_DESC] Script Date: 03/09/2017 16:46:06 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_EXTRNL_CRDNTL_A_TRNSCRPT_DESC]( [ISN_ST_EXTRNL_CRDNTL_A] [int] NOT NULL, [TRNSCRPT_DESC_COUNT] [smallint] NOT NULL, [cnxarraycolumn] [int] NOT NULL, [TRNSCRPT_DESC] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [cnxarraycolumn_2] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NULL ) ON [PRIMARY] |
Sample Data
| cnxarraycolumn | cnxarraycolumn_2 | ISN_ST_EXTRNL_CRDNTL_A | RowUpdatedOn | TRNSCRPT_DESC | TRNSCRPT_DESC_COUNT |
| 0 | 0 | 614201 | 2017-02-06T10:14:08.216-05:00 | DEGREE: B.S.- 1 JUNE, 1997 | 1 |
| 0 | 1 | 585772 | 2017-02-06T10:14:01.29-05:00 | TECHNLGY 10/13/1995 & BACHELOR | 4 |
| 0 | 1 | 837860 | 2017-02-06T10:14:17.14-05:00 | FASHION MERCHANDISING | 2 |
| 0 | 2 | 727275 | 2017-02-06T10:14:17.108-05:00 | ( ENGLISH) | 3 |
| 0 | 1 | 843548 | 2017-02-06T10:14:28.762-05:00 | 12/21/1996 | 2 |
| 0 | 0 | 764635 | 2017-02-06T10:14:17.124-05:00 | PER JS&A:EQUIVALENT TO U.S. | 3 |
| 0 | 1 | 806905 | 2017-02-06T10:14:17.14-05:00 | LANDSCAPE ARCH 02/22/2000 | 2 |
| 0 | 1 | 534418 | 2017-02-06T10:14:01.259-05:00 | 1999 | 2 |
| 0 | 0 | 264732 | 2017-02-06T10:13:40.776-05:00 | A.D. IN SCIENCE | 3 |
| 0 | 2 | 532573 | 2017-02-06T10:14:01.259-05:00 | (ESOL ENDORSMENT) AUG 6, 1999 | 3 |
| Powered by BI Documenter |
