|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | BATCH_A_FILES_ACCESSED |
| Schema | dbo |
| Row Count | 9977 |
| Data Size | 400 KB |
| Index Size | 216 KB |
| Create Date | 11/7/2012 2:39 PM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
ACCESS_TYPE |
varchar(1) |
True |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
FILE_NAME |
varchar(32) |
True |
False |
False |
|||
|
|
FILES_ACCESSED_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_BATCH_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_BATCH_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.BATCH_A_FILES_ACCESSED depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.BATCH_A_FILES_ACCESSED)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[BATCH_A_FILES_ACCESSED] Script Date: 03/09/2017 16:45:05 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[BATCH_A_FILES_ACCESSED]( [ISN_BATCH_A] [int] NOT NULL, [FILES_ACCESSED_COUNT] [smallint] NOT NULL, [FILE_NAME] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ACCESS_TYPE] [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 ) |
Sample Data
| ACCESS_TYPE | cnxarraycolumn | FILE_NAME | FILES_ACCESSED_COUNT | ISN_BATCH_A | RowUpdatedOn |
| U | 38 | UTL-CODE-TABLE-VIEW | 39 | 7604 | 2017-02-06T11:11:35.511-05:00 |
| U | 0 | SECURITY-USER-VIEW | 3 | 9376 | 2017-02-06T11:11:35.714-05:00 |
| U | 12 | AR-OBLIGATION | 50 | 7974 | 2017-02-06T11:11:35.558-05:00 |
| R | 1 | AP-EFT-VIEW | 16 | 9789 | 2017-02-06T11:11:35.729-05:00 |
| R | 9 | FAC195-SCHEDULE | 43 | 7907 | 2017-02-06T11:11:35.526-05:00 |
| R | 33 | FIP-VEN-ADDR-VIEW | 50 | 9291 | 2017-02-06T11:11:35.698-05:00 |
| R | 2 | ST-PROGRAMS-DEMO-V1 | 4 | 11175 | 2017-02-06T11:11:36.447-05:00 |
| R | 0 | AR-ADJUSTMENTS | 20 | 27437 | 2017-02-06T11:11:37.289-05:00 |
| R | 0 | BUDGET-CONTROL-VIEW | 3 | 23393 | 2017-02-06T11:11:37.289-05:00 |
| R | 13 | ST-CLASS-V1 | 15 | 4035 | 2017-02-06T11:11:35.417-05:00 |
| Powered by BI Documenter |
