table icon 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 true
Quoted Identifier true
Lock Escalation TABLE
Lock On Bulk Load false
Lob Data Space
Filestream Data Space ID
Has Unchecked Assembly Data false
Text In Row Limit (bytes) Option not set
Large Value Types Out Of Row false
FullText Change Tracking On false
Tracked By Cdc false
Published false
Schema Published false
Replicated false
Replication Filter false
Merge Published false
Sync Tran Subscribed false
MS Shipped false
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 true false false
2 phone varchar(15) true false false
3 socialnumber int true false false

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 true
Control
Delete
Insert dbo true
References
Select dbo true
Take Ownership
Update
View Change Tracking
View Definition

Column Level Permissions

Permissions for: duser

cusid
Permission Grantor Grant With Grant Deny
SELECT dbo true
REFERENCES
UPDATE

Objects that depend on [Phones]

Objects on which [Phones] depends

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