# Table: Phones

## Properties

Property | Value
--- | ---
Name | Phones
ID | 279672044
Owner | dbo
Schema | dbo
Filegroup | PRIMARY
Data Size (KB) | 0 KB
Index Size (KB) | 0 KB
Rows | 0
Unused (KB) | 0 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space |
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:58:10 PM
Create Date | 8/8/2010 5:57:50 PM

## Extended Properties

No extended properties defined.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | cusid | int |  |  |
2 | phone | varchar(15) |  |  |
3 | socialnumber | int |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

No primary key constraints defined.

## Primary Key Columns

No primary key columns defined.

## Foreign Keys

No foreign keys defined.

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

No default constraints defined.

## Indexes

No table indexes defined.

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

No referencing tables defined.

## Object Level Permissions

#### Permissions for: weekly_receipts

Permission | Grantor | Grant | With Grant Option | Deny
--- | --- | --- | --- | ---
Alter | dbo |  |  |
Control |  |  |  |
Delete |  |  |  |
Insert | dbo |  |  |
References |  |  |  |
Select | dbo |  |  |
Take Ownership |  |  |  |
Update |  |  |  |
View Change Tracking |  |  |  |
View Definition |  |  |  |

## Column Level Permissions

#### Permissions for: duser

#####

##### cusid

Permission | Grantor | Grant | With Grant | Deny
--- | --- | --- | --- | ---
SELECT | dbo |  |  |
REFERENCES |  |  |  |
UPDATE |  |  |  |

## Objects that depend on [Phones]

- dbo.Phones

## Objects on which [Phones] depends

- dbo.Phones
  - dbo.socialdflt
  - dbo.phonedflt

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Phones]( [cusid] [int] NULL, [phone] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [socialnumber] [int] NULL ) ON [PRIMARY]

#### See also

List of Tables