Table: ShipMethod Table: ShipMethod| Property | Value |
|---|---|
| Name | ShipMethod |
| ID | 1970106059 |
| Owner | dbo |
| Schema | Purchasing |
| Filegroup | PRIMARY |
| Data Size (KB) | 8 KB |
| Index Size (KB) | 40 KB |
| Rows | 5 |
| 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:41 PM |
| Create Date | 8/8/2010 5:21:53 PM |
| Name | Value |
|---|---|
| MS_Description | Shipping company lookup table. |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | ShipMethodID | int |
|
|
|
| 2 | Name | Name |
|
|
|
| 3 | ShipBase | money |
|
|
|
| 4 | ShipRate | money |
|
|
|
| 5 | rowguid | uniqueidentifier |
|
|
|
| 6 | ModifiedDate | datetime |
|
|
|
| Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set |
|---|---|---|---|---|---|---|---|
| ShipMethodID | 1 | 1 | 5 |
|
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK_ShipMethod_ShipMethodID |
|
MS_Description | Primary key (clustered) constraint |
| Name |
|---|
| ShipMethodID |
| Name | Column ID | Column | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named |
|---|---|---|---|---|---|---|---|---|
| CK_ShipMethod_ShipBase | 3 | ShipBase | ([ShipBase]>(0.00)) |
|
|
|
|
|
| CK_ShipMethod_ShipRate | 4 | ShipRate | ([ShipRate]>(0.00)) |
|
|
|
|
|
| Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|
| DF_ShipMethod_ShipBase | ShipBase | ((0.00)) |
|
MS_Description | Default constraint value of 0.0 |
| DF_ShipMethod_ShipRate | ShipRate | ((0.00)) |
|
MS_Description | Default constraint value of 0.0 |
| DF_ShipMethod_rowguid | rowguid | (newid()) |
|
MS_Description | Default constraint value of NEWID() |
| DF_ShipMethod_ModifiedDate | ModifiedDate | (getdate()) |
|
MS_Description | Default constraint value of GETDATE() |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK_ShipMethod_ShipMethodID | CLUSTERED |
|
|
|
|
|
| AK_ShipMethod_Name | NONCLUSTERED |
|
|
|
|
|
| AK_ShipMethod_rowguid | NONCLUSTERED |
|
|
|
|
|
| Name | Key Index ID | Is Disabled | Is Not For Replication | Is Not Trusted | Delete Action | Update Action | Is System Named | Referencing Object |
|---|---|---|---|---|---|---|---|---|
| FK_PurchaseOrderHeader_ShipMethod_ShipMethodID | 1 |
|
|
|
No action | No action |
|
Purchasing.PurchaseOrderHeader |
| FK_SalesOrderHeader_ShipMethod_ShipMethodID | 1 |
|
|
|
No action | No action |
|
Sales.SalesOrderHeader |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| PK_ShipMethod_ShipMethodID | Aug 8 2010 5:23PM | 5 | 5 | 3 | 1 | 4 |
|
5 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.2 | 4 | ShipMethodID |
| 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 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_ShipMethod_Name | Aug 8 2010 5:23PM | 5 | 5 | 5 | 0 | 36 |
|
5 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.2 | 32 | Name |
| 0.2 | 36 | Name, ShipMethodID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| CARGO TRANSPORT 5 | 0 | 1 | 0 | 1 |
| OVERNIGHT J-FAST | 0 | 1 | 0 | 1 |
| OVERSEAS - DELUXE | 0 | 1 | 0 | 1 |
| XRQ - TRUCK GROUND | 0 | 1 | 0 | 1 |
| ZY - EXPRESS | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_ShipMethod_rowguid | Aug 8 2010 5:23PM | 5 | 5 | 5 | 0 | 20 |
|
5 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.2 | 16 | rowguid |
| 0.2 | 20 | rowguid, ShipMethodID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 107e8356-e7a8-463d-b60c-079fff467f3f | 0 | 1 | 0 | 1 |
| 3455079b-f773-4dc6-8f1e-2a58649c4ab8 | 0 | 1 | 0 | 1 |
| b166019a-b134-4e76-b957-2b0490c610ed | 0 | 1 | 0 | 1 |
| 6be756d9-d7be-4463-8f2c-ae60c710d606 | 0 | 1 | 0 | 1 |
| 22f4e461-28cf-4ace-a980-f686cf112ec8 | 0 | 1 | 0 | 1 |
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Purchasing].[ShipMethod]( [ShipMethodID] [int] IDENTITY(1,1) NOT NULL, [Name] [dbo].[Name] NOT NULL, [ShipBase] [money] NOT NULL, [ShipRate] [money] 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 ShipMethod records.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ShipMethodID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipping company name.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'Name' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Minimum shipping charge.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ShipBase' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipping charge per pound.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ShipRate' 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'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @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'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipping company lookup table.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod' |