|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | ST_FACTS_APPL_A_ADDRESSES |
| Schema | dbo |
| Row Count | 87065 |
| Data Size | 3616 KB |
| Index Size | 1504 KB |
| Create Date | 8/15/2012 1:36 PM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
ADDR_TY |
varchar(2) |
True |
False |
False |
|||
|
|
ADDRESSES_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
CITY |
varchar(30) |
True |
False |
False |
|||
|
|
CNTRY |
varchar(3) |
True |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_ST_FACTS_APPL_A |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
|
|
STATE |
varchar(2) |
True |
False |
False |
|||
|
|
STATE_PROVINCE |
varchar(35) |
True |
False |
False |
|||
|
|
STREET_1 |
varchar(35) |
True |
False |
False |
|||
|
|
STREET_2 |
varchar(35) |
True |
False |
False |
|||
|
|
ZIP_CD |
varchar(15) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_ST_FACTS_APPL_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.ST_FACTS_APPL_A_ADDRESSES depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.ST_FACTS_APPL_A_ADDRESSES)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[ST_FACTS_APPL_A_ADDRESSES] Script Date: 03/09/2017 16:46:07 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_FACTS_APPL_A_ADDRESSES]( [ISN_ST_FACTS_APPL_A] [int] NOT NULL, [ADDRESSES_COUNT] [smallint] NOT NULL, [ADDR_TY] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STREET_1] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STREET_2] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CITY] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ZIP_CD] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STATE_PROVINCE] [varchar](35) 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
| ADDR_TY | ADDRESSES_COUNT | CITY | CNTRY | cnxarraycolumn | ISN_ST_FACTS_APPL_A | RowUpdatedOn | STATE | STATE_PROVINCE | STREET_1 | STREET_2 | ZIP_CD |
| 03 | 5 | WEST PALM BEACH | US | 2 | 8423 | 2017-02-06T11:16:31.008-05:00 | FL | 2100 n Australian ave apt413s | 33407 | ||
| 03 | 5 | WEST PALM BEACH | US | 2 | 12763 | 2017-02-06T11:16:32.131-05:00 | FL | 632 Riverside drv | 33410 | ||
| 5 | 3 | 8732 | 2017-02-06T11:16:31.101-05:00 | ||||||||
| 03 | 5 | US | 2 | 16725 | 2017-02-06T11:16:33.301-05:00 | FL | |||||
| 5 | 3 | 747 | 2017-02-06T11:16:28.871-05:00 | ||||||||
| 01 | 5 | Boynton Beach | US | 0 | 13237 | 2017-02-06T11:16:32.271-05:00 | FL | 10735 Grande Palladium Way | 334365061 | ||
| 5 | 3 | 4235 | 2017-02-06T11:16:29.838-05:00 | ||||||||
| 5 | 3 | 11866 | 2017-02-06T11:16:31.897-05:00 | ||||||||
| 02 | 5 | US | 1 | 4593 | 2017-02-06T11:16:29.931-05:00 | FL | |||||
| 02 | 5 | Boynton Beach | US | 1 | 4224 | 2017-02-06T11:16:29.838-05:00 | FL | 1931 NE 2nd Lane | 33435 |
| Powered by BI Documenter |
