Description
High-level product categorization.
Table properties
| name | value |
|---|
| name | [Production].[ProductCategory] |
| created | Mar 19 2009 9:08PM |
| modified | Mar 19 2009 9:08PM
|
| ansi nulls | on
|
| quoted identifier | on
|
| row count | 4 |
| Size of data | 8 kb |
| Size of indexes | 40 kb |
| Maximum size of a single row | 228 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| ProductCategoryID | int identity(1,1) | 10 | 4 | | no
| yes
| |
| no
| Primary key for ProductCategory records.
|
| Name | Name | 50 | 200 | | no
|
| |
| no
| Category description.
|
| rowguid | uniqueidentifier | 36 | 16 | (newid()) | no
|
| |
| no
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| ModifiedDate | datetime | 23 | 8 | (getdate()) | no
|
| |
| no
| Date and time the record was last updated.
|
Indexes
Referenced by
Foreign key graph
Defaults
Dependency graph
Objects that [Production].[ProductCategory] depends on
| name | object type | level |
|---|
| Name | type | 1 |
Sample rows
| ProductCategoryID | Name | rowguid | ModifiedDate |
|---|
| 1
| Bikes
| cfbda25c-df71-47a7-b81b-64ee161aa37c
| 6/1/1998 12:00:00 AM
|
| 2
| Components
| c657828d-d808-4aba-91a3-af2ce02300e9
| 6/1/1998 12:00:00 AM
|
| 3
| Clothing
| 10a7c342-ca82-48d4-8a38-46a2eb089b74
| 6/1/1998 12:00:00 AM
|
| 4
| Accessories
| 2be3be36-d9a2-4eee-b593-ed895d97c2a6
| 6/1/1998 12:00:00 AM
|
Code
CREATE TABLE [Production].[ProductCategory](
[ProductCategoryID] [int] IDENTITY(1,1) NOT NULL,
[Name] [dbo].[Name] NOT NULL,
[ProductCategoryID] [int] IDENTITY(1,1) NOT NULL,
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,
[ModifiedDate] [datetime] NOT NULL,
CONSTRAINT [PK_ProductCategory_ProductCategoryID] PRIMARY KEY CLUSTERED
(
[ProductCategoryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [Production].[ProductCategory] ADD CONSTRAINT [DF_ProductCategory_rowguid] DEFAULT (newid()) FOR [rowguid]
ALTER TABLE [Production].[ProductCategory] ADD CONSTRAINT [DF_ProductCategory_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]