Table - dbo.ST_LTTR_BLCK_A

Properties

Property	Value
Name	ST_LTTR_BLCK_A_BLOCK
Schema	dbo
Row Count	1491
Data Size	24 KB
Index Size	56 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
BLOCK	varchar(5)	True	False	False
BLOCK_COUNT	smallint(5, 0)	False	False	False
cnxarraycolumn	smallint(5, 0)	False	False	False
ISN_ST_LTTR_BLCK_A	int(10, 0)	False	False	False

Triggers

Name

Insert

Update

Delete

Instead

Indexes

Name	Clustered	Columns
U1X1546TWRHSH0	False	ISN_ST_LTTR_BLCK_A, cnxarraycolumn

Foreign Key Constraints

Name

Columns

Referenced Table

Referenced Columns

Checked

Check Constraints

Name

Text

Checked

Parent Dependencies (objects that dbo.ST_LTTR_BLCK_A_BLOCK depends on)

Name

Type

Child Dependencies (objects that depend on dbo.ST_LTTR_BLCK_A_BLOCK)

Name

Type

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[ST_LTTR_BLCK_A_BLOCK] Script Date: 03/09/2017 16:46:11 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_LTTR_BLCK_A_BLOCK](
    [ISN_ST_LTTR_BLCK_A] [int] NOT NULL,
    [BLOCK_COUNT] [smallint] NOT NULL,
    [BLOCK] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [cnxarraycolumn] [smallint] NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)

Sample Data

BLOCK	BLOCK_COUNT	cnxarraycolumn	ISN_ST_LTTR_BLCK_A
ADMBA	21	4	720
ADDR2	5	0	1468202
HTML2	6	4	1468258
MGRD7	7	3	422
DEARH	6	1	1468258
ADI07	11	9	122
ADC01	9	2	438
FUN2	2	1	2479170
DEARH	8	1	1396
AV104	8	5	1487754