|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | AR_CONDITIONS_A_CLS_ITEM_ID |
| Schema | dbo |
| Row Count | 96059 |
| Data Size | 2096 KB |
| Index Size | 2040 KB |
| Create Date | 11/7/2012 8:27 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
CLS_ITEM_ID |
int(10, 0) |
True |
False |
False |
|||
|
|
CLS_ITEM_ID_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_AR_CONDITIONS_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_AR_CONDITIONS_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.AR_CONDITIONS_A_CLS_ITEM_ID depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.AR_CONDITIONS_A_CLS_ITEM_ID)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[AR_CONDITIONS_A_CLS_ITEM_ID] Script Date: 03/09/2017 16:44:57 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AR_CONDITIONS_A_CLS_ITEM_ID]( [ISN_AR_CONDITIONS_A] [int] NOT NULL, [CLS_ITEM_ID_COUNT] [smallint] NOT NULL, [CLS_ITEM_ID] [int] NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| CLS_ITEM_ID | CLS_ITEM_ID_COUNT | cnxarraycolumn | ISN_AR_CONDITIONS_A | RowUpdatedOn |
| 70298 | 1 | 0 | 201117 | 2017-02-06T10:03:21.436-05:00 |
| 52445 | 2 | 1 | 122230 | 2017-02-06T10:03:16.319-05:00 |
| 172912 | 11 | 3 | 809657 | 2017-02-06T10:03:57.254-05:00 |
| 152113 | 5 | 0 | 712689 | 2017-02-06T10:03:50.998-05:00 |
| 15656 | 2 | 0 | 18389 | 2017-02-06T10:03:09.892-05:00 |
| 176144 | 1 | 0 | 913260 | 2017-02-06T10:04:02.059-05:00 |
| 40277 | 2 | 1 | 88528 | 2017-02-06T10:03:14.432-05:00 |
| 35193 | 3 | 0 | 62428 | 2017-02-06T10:03:12.638-05:00 |
| 206953 | 2 | 1 | 1152719 | 2017-02-06T10:04:17.877-05:00 |
| 58290 | 1 | 0 | 139075 | 2017-02-06T10:03:17.489-05:00 |
| Powered by BI Documenter |
