|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | ST_INSTITUTION_A_INST_ALT_NM |
| Schema | dbo |
| Row Count | 2086 |
| Data Size | 104 KB |
| Index Size | 72 KB |
| Create Date | 8/15/2012 1:36 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 |
|||
|
|
INST_ALT_NM |
varchar(32) |
True |
False |
False |
|||
|
|
INST_ALT_NM_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_ST_INSTITUTION_A |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_ST_INSTITUTION_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.ST_INSTITUTION_A_INST_ALT_NM depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.ST_INSTITUTION_A_INST_ALT_NM)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[ST_INSTITUTION_A_INST_ALT_NM] Script Date: 03/09/2017 16:46:09 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_INSTITUTION_A_INST_ALT_NM]( [ISN_ST_INSTITUTION_A] [int] NOT NULL, [INST_ALT_NM_COUNT] [smallint] NOT NULL, [INST_ALT_NM] [varchar](32) 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 | INST_ALT_NM | INST_ALT_NM_COUNT | ISN_ST_INSTITUTION_A | RowUpdatedOn |
| 4 | OHDELA! | 7 | 42295 | 2017-02-06T11:07:56.376-05:00 |
| 0 | UNIVERSITY OF SOUTHERN COLORADO | 1 | 23102 | 2017-02-06T11:07:56.095-05:00 |
| 0 | CHAFFEY COMMUNITY COLLEGE | 1 | 22965 | 2017-02-06T11:07:56.095-05:00 |
| 1 | BRIDGE ALTERNATIVE HIGH SCHOOL | 2 | 33960 | 2017-02-06T11:07:56.111-05:00 |
| 0 | STONEMAN DOUGLAS HIGH SCHOOL | 2 | 1012 | 2017-02-06T11:07:56.095-05:00 |
| 0 | HAITIAN CTR FOR TRAINING JOURNAL | 1 | 36724 | 2017-02-06T11:07:56.111-05:00 |
| 0 | HS OF BTMF AT JFK | 2 | 42598 | 2017-02-06T11:07:56.376-05:00 |
| 0 | ECOLE SUPER TECH ET DE GESTION | 1 | 40412 | 2017-02-06T11:07:56.361-05:00 |
| 0 | DADE CNTY PUBLIC SCHS CORP AC | 1 | 38566 | 2017-02-06T11:07:56.111-05:00 |
| 1 | 1968 BL88AB DIPLOMA DE BACHILLER | 2 | 30272 | 2017-02-06T11:07:56.111-05:00 |
| Powered by BI Documenter |
