DWStaging
 dbo.BUDGET_PREP_FILE_REPORT_DISPLAY_GROUP (Table)
  Properties
Property Value
Name BUDGET_PREP_FILE_REPORT_DISPLAY_GROUP
Schema dbo
Row Count 6
Data Size 8 KB
Index Size 24 KB
Create Date 10/24/2012 1:57 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
 
ISN_BUDGET_PREP_FILE
int(10, 0)
False
False
False
 
ITER_REPORT_DISPLAY
int(10, 0)
True
False
False
 
REPORT_DISPLAY_GROUP_COUNT
smallint(5, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_BUDGET_PREP_FILE, cnxarraycolumn
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.BUDGET_PREP_FILE_REPORT_DISPLAY_GROUP depends on)
Name Type
  Child Dependencies (objects that depend on dbo.BUDGET_PREP_FILE_REPORT_DISPLAY_GROUP)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[BUDGET_PREP_FILE_REPORT_DISPLAY_GROUP] Script Date: 03/09/2017 16:45:07 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[BUDGET_PREP_FILE_REPORT_DISPLAY_GROUP](
    [ISN_BUDGET_PREP_FILE] [int] NOT NULL,
    [REPORT_DISPLAY_GROUP_COUNT] [smallint] NOT NULL,
    [ITER_REPORT_DISPLAY] [int] NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
cnxarraycolumn ISN_BUDGET_PREP_FILE ITER_REPORT_DISPLAY REPORT_DISPLAY_GROUP_COUNT RowUpdatedOn
0 43834 1 1 2017-02-06T11:18:45.715-05:00
0 22845 1 2 2017-02-06T11:18:45.715-05:00
0 62903 1 1 2017-02-06T11:18:45.715-05:00
0 80039 1 1 2017-02-06T11:18:45.715-05:00
0 1 1 1 2017-02-06T11:18:45.715-05:00
1 22845 2 2 2017-02-06T11:18:45.715-05:00
Powered by BI Documenter