Table - dbo.IA_WEB_ENABLEMENT

Properties

Property	Value
Name	IA_WEB_ENABLEMENT_A
Schema	dbo
Row Count	0
Data Size	0 KB
Index Size	0 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
ELEMENT_NAME	varchar(100)	True	False	False
ELEMENT_OCC_IND	varchar(1)	True	False	False
FIELD_INFO	varchar(250)	True	False	False
ISN_IA_WEB_ENABLEMENT_A	int(10, 0)	False	False	False
PARENT_SEND_SEQ	int(10, 0)	True	False	False
RECEIVE_SEQ	int(10, 0)	True	False	False
RowUpdatedOn	datetime2(27, 7)	True	False	False
SEND_SEQ	int(10, 0)	True	False	False
TABLE_NAME	varchar(50)	True	False	False
XML_FL_IND	varchar(1)	True	False	False

Triggers

Name

Insert

Update

Delete

Instead

Indexes

Name	Clustered	Columns
U15EFRWP3UZXKW	False	ISN_IA_WEB_ENABLEMENT_A

Foreign Key Constraints

Name

Columns

Referenced Table

Referenced Columns

Checked

Check Constraints

Name

Text

Checked

Parent Dependencies (objects that dbo.IA_WEB_ENABLEMENT_A depends on)

Name

Type

Child Dependencies (objects that depend on dbo.IA_WEB_ENABLEMENT_A)

Name

Type

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[IA_WEB_ENABLEMENT_A] Script Date: 03/09/2017 16:45:38 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[IA_WEB_ENABLEMENT_A](
    [ISN_IA_WEB_ENABLEMENT_A] [int] NOT NULL,
    [TABLE_NAME] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ELEMENT_NAME] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ELEMENT_OCC_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIELD_INFO] [varchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVE_SEQ] [int] NULL,
    [SEND_SEQ] [int] NULL,
    [PARENT_SEND_SEQ] [int] NULL,
    [XML_FL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)