# Table: ProductSubcategory

## Properties

Property | Value
--- | ---
Name | ProductSubcategory
ID | 418100530
Owner | dbo
Schema | Production
Filegroup | PRIMARY
Data Size (KB) | 8 KB
Index Size (KB) | 40 KB
Rows | 37
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:23:40 PM
Create Date | 8/8/2010 5:21:52 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Product subcategories. See ProductCategory table.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | ProductSubcategoryID | int |  |  |
2 | ProductCategoryID | int |  |  |
3 | Name | Name |  |  |
4 | rowguid | uniqueidentifier |  |  |
5 | ModifiedDate | datetime |  |  |

## Identity Columns

Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | --- | --- | ---
ProductSubcategoryID | 1 | 1 | 37 |  |  |  |

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_ProductSubcategory_ProductSubcategoryID |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
ProductSubcategoryID

## Foreign Keys

Name | Referenced Object | Update Action | Delete Action
--- | --- | --- | ---
FK_ProductSubcategory_ProductCategory_ProductCategoryID | Production.ProductCategory | No action | No action

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_ProductSubcategory_rowguid | rowguid | (newid()) |  | MS_Description | Default constraint value of NEWID()
DF_ProductSubcategory_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_ProductSubcategory_ProductSubcategoryID | CLUSTERED |  |  |  |  |
AK_ProductSubcategory_Name | NONCLUSTERED |  |  |  |  |
AK_ProductSubcategory_rowguid | NONCLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## 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_Product_ProductSubcategory_ProductSubcategoryID | 1 |  |  |  | No action | No action |  | Production.Product

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_ProductSubcategory_ProductSubcategoryID | Aug 8 2010 5:22PM | 37 | 37 | 19 | 1 | 4 |  |  | 37

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.02702703 | 4 | ProductSubcategoryID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 1 | 0 | 1
3 | 1 | 1 | 1 | 1
5 | 1 | 1 | 1 | 1
7 | 1 | 1 | 1 | 1
9 | 1 | 1 | 1 | 1
11 | 1 | 1 | 1 | 1
13 | 1 | 1 | 1 | 1
15 | 1 | 1 | 1 | 1
17 | 1 | 1 | 1 | 1
19 | 1 | 1 | 1 | 1
21 | 1 | 1 | 1 | 1
23 | 1 | 1 | 1 | 1
25 | 1 | 1 | 1 | 1
27 | 1 | 1 | 1 | 1
29 | 1 | 1 | 1 | 1
31 | 1 | 1 | 1 | 1
33 | 1 | 1 | 1 | 1
35 | 1 | 1 | 1 | 1
37 | 1 | 1 | 1 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_ProductSubcategory_Name | Aug 8 2010 5:23PM | 37 | 37 | 37 | 0 | 21.78378 |  |  | 37

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.02702703 | 17.78378 | Name
0.02702703 | 21.78378 | Name, ProductSubcategoryID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
Bib-Shorts | 0 | 1 | 0 | 1
Bike Racks | 0 | 1 | 0 | 1
Bike Stands | 0 | 1 | 0 | 1
Bottles and Cages | 0 | 1 | 0 | 1
Bottom Brackets | 0 | 1 | 0 | 1
Brakes | 0 | 1 | 0 | 1
Caps | 0 | 1 | 0 | 1
Chains | 0 | 1 | 0 | 1
Cleaners | 0 | 1 | 0 | 1
Cranksets | 0 | 1 | 0 | 1
Derailleurs | 0 | 1 | 0 | 1
Fenders | 0 | 1 | 0 | 1
Forks | 0 | 1 | 0 | 1
Gloves | 0 | 1 | 0 | 1
Handlebars | 0 | 1 | 0 | 1
Headsets | 0 | 1 | 0 | 1
Helmets | 0 | 1 | 0 | 1
Hydration Packs | 0 | 1 | 0 | 1
Jerseys | 0 | 1 | 0 | 1
Lights | 0 | 1 | 0 | 1
Locks | 0 | 1 | 0 | 1
Mountain Bikes | 0 | 1 | 0 | 1
Mountain Frames | 0 | 1 | 0 | 1
Panniers | 0 | 1 | 0 | 1
Pedals | 0 | 1 | 0 | 1
Pumps | 0 | 1 | 0 | 1
Road Bikes | 0 | 1 | 0 | 1
Road Frames | 0 | 1 | 0 | 1
Saddles | 0 | 1 | 0 | 1
Shorts | 0 | 1 | 0 | 1
Socks | 0 | 1 | 0 | 1
Tights | 0 | 1 | 0 | 1
Tires and Tubes | 0 | 1 | 0 | 1
Touring Bikes | 0 | 1 | 0 | 1
Touring Frames | 0 | 1 | 0 | 1
Vests | 0 | 1 | 0 | 1
Wheels | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_ProductSubcategory_rowguid | Aug 8 2010 5:23PM | 37 | 37 | 32 | 1 | 20 |  |  | 37

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.02702703 | 16 | rowguid
0.02702703 | 20 | rowguid, ProductSubcategoryID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
7c782bbe-5a16-495a-aa50-10afe5a84af2 | 0 | 1 | 0 | 1
9b7dff41-9fa3-4776-8def-2c9a48c8b779 | 0 | 1 | 0 | 1
fe4d46f2-c87c-48c5-a4a1-3f55712d80b1 | 0 | 1 | 0 | 1
5515f857-075b-4f9a-87b7-43b4997077b3 | 1 | 1 | 1 | 1
000310c0-bcc8-42c4-b0c3-45ae611af06b | 0 | 1 | 0 | 1
d43ba4a3-ef0d-426b-90eb-4be4547dd30c | 0 | 1 | 0 | 1
61b21b65-e16a-4be7-9300-4d8e9db861be | 0 | 1 | 0 | 1
1a5ba5b3-03c3-457c-b11e-4fa85ede87da | 0 | 1 | 0 | 1
2d364ade-264a-433c-b092-4fcbf3804e01 | 0 | 1 | 0 | 1
5deb3e55-9897-4416-b18a-515e970bc2d1 | 0 | 1 | 0 | 1
430dd6a8-a755-4b23-bb05-52520107da5f | 0 | 1 | 0 | 1
d2e3f1a8-56c4-4f36-b29d-5659fc0d2789 | 0 | 1 | 0 | 1
b5f9ba42-b69b-4fdd-b2ec-57fb7b42e3cf | 0 | 1 | 0 | 1
1830d70c-aa2a-40c0-a271-5ba86f38f8bf | 0 | 1 | 0 | 1
67b58d2b-5798-4a90-8c6c-5ddacf057171 | 0 | 1 | 0 | 1
3c17c9ae-e906-48b4-bdd3-60e28d47dcdf | 0 | 1 | 0 | 1
6d24ac07-7a84-4849-864a-865a14125bc9 | 1 | 1 | 1 | 1
646a8906-fc87-4267-a443-9c6d791e6693 | 1 | 1 | 1 | 1
f5e07a33-c9e0-439c-b5f3-9f25fb65becc | 0 | 1 | 0 | 1
4624b5ce-66d6-496b-9201-c053df3556cc | 1 | 1 | 1 | 1
701019c3-09fe-4949-8386-c6ce686474e5 | 0 | 1 | 0 | 1
e93a7231-f16c-4b0f-8c41-c73fdec62da0 | 0 | 1 | 0 | 1
954178ba-624f-42db-95f6-ca035f36d130 | 0 | 1 | 0 | 1
43521287-4b0b-438e-b80e-d82d9ad7c9f0 | 1 | 1 | 1 | 1
3002a5d5-fec3-464b-bef3-e0f81d35f431 | 0 | 1 | 0 | 1
a9e54089-8a1e-4cf5-8646-e3801f685934 | 0 | 1 | 0 | 1
4f644521-422b-4f19-974a-e3df6102567e | 0 | 1 | 0 | 1
02c5061d-ecdc-4274-b5f1-e91d76bc3f37 | 0 | 1 | 0 | 1
049fffa3-9d30-46df-82f7-f20730ec02b3 | 0 | 1 | 0 | 1
19646983-3fa0-4773-9a0c-f34c49df9bc8 | 0 | 1 | 0 | 1
9ad3bcf0-244d-4ec4-a6a0-fb701351c6a3 | 0 | 1 | 0 | 1
9ad7fe93-5ba0-4736-b578-ff80a2071297 | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
_WA_Sys_00000002_18EBB532 | Aug 8 2010 5:23PM | 37 | 37 | 4 | 0 | 4 |  |  | 37

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.25 | 4 | ProductCategoryID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 3 | 0 | 1
2 | 0 | 14 | 0 | 1
3 | 0 | 8 | 0 | 1
4 | 0 | 12 | 0 | 1

## Objects that depend on [ProductSubcategory]

- Production.ProductSubcategory
  - Production.Product
    - dbo.KrystianProductView
    - dbo.ufnGetProductDealerPrice
      - Person.functionSynonym
    - dbo.ufnGetProductListPrice
    - dbo.ufnGetProductStandardCost
    - dbo.uspGetBillOfMaterials
      - HumanResources.ProcedureSynonym
    - dbo.uspGetWhereUsedProductID
    - Production.BillOfMaterials
    - Production.ProductCostHistory
    - Production.ProductDocument
    - Production.ProductInventory
      - dbo.ufnGetStock
    - Production.ProductListPriceHistory
    - Production.ProductProductPhoto
    - Production.ProductReview
    - Production.TransactionHistory
      - Production.WorkOrder
        - Production.iWorkOrder
        - Production.uWorkOrder
        - Production.WorkOrderRouting
      - Purchasing.PurchaseOrderDetail
        - Purchasing.iPurchaseOrderDetail
        - Purchasing.uPurchaseOrderDetail
      - Sales.SalesOrderDetail
        - Sales.iduSalesOrderDetail
        - Sales.ufn_SalesByStore
    - Production.uspGetList
    - Production.vProductAndDescription
    - Purchasing.ProductVendor
    - Sales.ShoppingCartItem
    - Sales.SpecialOfferProduct

## Objects on which [ProductSubcategory] depends

- Production.ProductSubcategory
  - Production.ProductCategory
    - dbo.Name

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Production].[ProductSubcategory]( [ProductSubcategoryID] [int] IDENTITY(1,1) NOT NULL, [ProductCategoryID] [int] NOT NULL, [Name] [dbo].[Name] NOT NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for ProductSubcategory records.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductSubcategory', @level2type=N'COLUMN',@level2name=N'ProductSubcategoryID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product category identification number. Foreign key to ProductCategory.ProductCategoryID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductSubcategory', @level2type=N'COLUMN',@level2name=N'ProductCategoryID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Subcategory description.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductSubcategory', @level2type=N'COLUMN',@level2name=N'Name' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductSubcategory', @level2type=N'COLUMN',@level2name=N'rowguid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductSubcategory', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product subcategories. See ProductCategory table.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductSubcategory'

#### See also

List of Tables