Table: ProductDescription

Properties

Property	Value
Name	ProductDescription
ID	2069582411
Owner	dbo
Schema	Production
Filegroup	PRIMARY
Data Size (KB)	144 KB
Index Size (KB)	56 KB
Rows	762
Unused (KB)	48 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:23:45 PM
Create Date	8/8/2010 5:21:51 PM

Extended Properties

Columns

Column ID	Column Name	Datatype	Nullable	Is Sparse	Is Column Set
1	ProductDescriptionID	int
2	Description	nvarchar(400)
3	rowguid	uniqueidentifier
4	ModifiedDate	datetime

Identity Columns

Column	Seed Value	Increment Value	Last Value	Is Not For Replication	Is Computed	Is Sparse	Is Column Set
ProductDescriptionID	1	1	2010

Primary Key Constraints

Name	Is System Named	Extended Property Name	Extended Property Value
PK_ProductDescription_ProductDescriptionID		MS_Description	Primary key (clustered) constraint

Primary Key Columns

Foreign Keys

Column Level Check Constraints

Table Level Check Constraints

Default Constraints

Name	Column	Definition	Is System Named	Extended Property Name	Extended Property Value
DF_ProductDescription_rowguid	rowguid	(newid())		MS_Description	Default constraint value of NEWID()
DF_ProductDescription_ModifiedDate	ModifiedDate	(getdate())		MS_Description	Default constraint value of GETDATE()

Indexes

Name	Index Type	Primary Key	Unique	Unique Constraint	Ignore Duplicate Key	Disabled
PK_ProductDescription_ProductDescriptionID	CLUSTERED
AK_ProductDescription_rowguid	NONCLUSTERED

FullText Indexes

Referencing Tables

Name	Key Index ID	Is Disabled	Is Not For Replication	Is Not Trusted	Delete Action	Update Action	Is System Named	Referencing Object
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID	1				No action	No action		Production.ProductModelProductDescriptionCulture

Object Level Permissions

Column Level Permissions

Permissions for: JohnBlack

Description

Permission	Grantor	Grant	With Grant	Deny
SELECT	dbo
REFERENCES
UPDATE

Statistics

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
PK_ProductDescription_ProductDescriptionID	Aug 8 2010 5:22PM	762	762	188	1	4			762

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
AK_ProductDescription_rowguid	Aug 8 2010 5:23PM	762	762	185	1	20			762

Detailed Statistics Density

Detailed Statistics Histogram

Objects that depend on [ProductDescription]

• Production.ProductDescription
  • Production.ProductModelProductDescriptionCulture
    • Production.vProductAndDescription

Objects on which [ProductDescription] depends

• Production.ProductDescription

SQL

See also