|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | ST_ADDRESSES_A |
| Schema | dbo |
| Row Count | 1341139 |
| Data Size | 105128 KB |
| Index Size | 20024 KB |
| Create Date | 8/15/2012 12:45 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 |
|||
|
|
CITY |
varchar(20) |
True |
False |
False |
|||
|
|
CNTRY |
varchar(3) |
True |
False |
False |
|||
|
|
ISN_ST_ADDRESSES_A |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
|
|
STATE |
varchar(2) |
True |
False |
False |
|||
|
|
STREET_1 |
varchar(32) |
True |
False |
False |
|||
|
|
STREET_2 |
varchar(32) |
True |
False |
False |
|||
|
|
STUDENT_ID |
varchar(9) |
True |
False |
False |
|||
|
|
ZIP_CD |
varchar(11) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_ST_ADDRESSES_A |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.ST_ADDRESSES_A depends on)
| Name | Type |
View |
|
StoredProcedure |
Child Dependencies (objects that depend on dbo.ST_ADDRESSES_A)
| Name | Type |
VIEW |
|
STOREDPROCEDURE |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[ST_ADDRESSES_A] Script Date: 03/09/2017 16:45:56 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_ADDRESSES_A]( [ISN_ST_ADDRESSES_A] [int] NOT NULL, [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADDR_TY] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STREET_1] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STREET_2] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ZIP_CD] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| ADDR_TY | CITY | CNTRY | ISN_ST_ADDRESSES_A | RowUpdatedOn | STATE | STREET_1 | STREET_2 | STUDENT_ID | ZIP_CD |
| 01 | BOCA RATON | US | 96031 | 2017-02-06T10:04:52.744-05:00 | FL | 5200 SW 20 STR | G07084908 | 33486 | |
| 01 | WEST PALM BEACH | US | 93295 | 2017-02-06T10:04:52.619-05:00 | FL | 3D AMHERST COURT | V07054240 | 33411 | |
| 03 | WEST PALM BEACH | US | 640609 | 2017-02-06T10:05:20.075-05:00 | FL | 523 PARKWOOD DRIVE SOUTH | D11514759 | 33411 | |
| 01 | WEST PALM BEACH | US | 165040 | 2017-02-06T10:04:56.02-05:00 | FL | 520 HIGH ST | J07840051 | 33405 | |
| 01 | WEST PALM BEACH | US | 286355 | 2017-02-06T10:05:02.041-05:00 | FL | 5209 APPLECREST | J09091216 | 33410 | |
| 01 | WEST PALM BEACH | US | 764968 | 2017-02-06T10:05:25.987-05:00 | FL | 526 BOBWHITE DR | M12365912 | 334111717 | |
| 01 | POMPANO BEACH | US | 931529 | 2017-02-06T10:05:34.786-05:00 | FL | 5242 NW 114TH BLVD | A13327473 | 33065 | |
| 01 | BOCA RATON | US | 599485 | 2017-02-06T10:05:18.016-05:00 | FL | 5215 N.W. 3RD AVE | E11681020 | 33487 | |
| 05 | WEST PALM BEACH | US | 534964 | 2017-02-06T10:05:14.724-05:00 | FL | 5234 CAMP LEE DR | D06598130 | 33417 | |
| 01 | WEST PALM BEACH | US | 406409 | 2017-02-06T10:05:08-05:00 | FL | 5264 W 28TH AVE | J10369197 | 33404 |
| Powered by BI Documenter |
