Table - dbo.SECURITY_MODULE_LOG_A

Properties

Property	Value
Name	SECURITY_MODULE_LOG_A_LEVELS
Schema	dbo
Row Count	487
Data Size	16 KB
Index Size	40 KB
Create Date	8/15/2012 11:34 AM
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_SECURITY_MODULE_LOG_A	int(10, 0)	False	False	False
LEVELS	int(10, 0)	True	False	False
LEVELS_COUNT	smallint(5, 0)	False	False	False
RowUpdatedOn	datetime2(27, 7)	False	False	False

Triggers

Name

Insert

Update

Delete

Instead

Indexes

Name	Clustered	Columns
U20JC7QMB1L42B	False	ISN_SECURITY_MODULE_LOG_A, cnxarraycolumn

Foreign Key Constraints

Name

Columns

Referenced Table

Referenced Columns

Checked

Check Constraints

Name

Text

Checked

Parent Dependencies (objects that dbo.SECURITY_MODULE_LOG_A_LEVELS depends on)

Name

Type

Child Dependencies (objects that depend on dbo.SECURITY_MODULE_LOG_A_LEVELS)

Name

Type

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[SECURITY_MODULE_LOG_A_LEVELS] Script Date: 03/09/2017 16:45:53 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[SECURITY_MODULE_LOG_A_LEVELS](
    [ISN_SECURITY_MODULE_LOG_A] [int] NOT NULL,
    [LEVELS_COUNT] [smallint] NOT NULL,
    [LEVELS] [int] NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)

Sample Data

cnxarraycolumn	ISN_SECURITY_MODULE_LOG_A	LEVELS	LEVELS_COUNT	RowUpdatedOn
3	1941	4	5	2017-02-06T11:24:17.279-05:00
2	1434	3	4	2017-02-06T11:24:17.279-05:00
0	1422	1	1	2017-02-06T11:24:17.279-05:00
2	1443	3	9	2017-02-06T11:24:17.279-05:00
1	1413	2	3	2017-02-06T11:24:17.279-05:00
1	1991	2	2	2017-02-06T11:24:17.279-05:00
0	1633	1	1	2017-02-06T11:24:17.279-05:00
0	1970	1	2	2017-02-06T11:24:17.279-05:00
0	2002	1	2	2017-02-06T11:24:17.279-05:00
1	1423	2	5	2017-02-06T11:24:17.279-05:00