Table: SalesTaxRate Table: SalesTaxRate| Property | Value |
|---|---|
| Name | SalesTaxRate |
| ID | 1586104691 |
| Owner | dbo |
| Schema | Sales |
| Filegroup | PRIMARY |
| Data Size (KB) | 8 KB |
| Index Size (KB) | 40 KB |
| Rows | 29 |
| 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:43 PM |
| Create Date | 8/8/2010 5:21:52 PM |
| Name | Value |
|---|---|
| MS_Description | Tax rate lookup table. |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | SalesTaxRateID | int |
|
|
|
| 2 | StateProvinceID | int |
|
|
|
| 3 | TaxType | tinyint |
|
|
|
| 4 | TaxRate | smallmoney |
|
|
|
| 5 | Name | Name |
|
|
|
| 6 | rowguid | uniqueidentifier |
|
|
|
| 7 | ModifiedDate | datetime |
|
|
|
| Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set |
|---|---|---|---|---|---|---|---|
| SalesTaxRateID | 1 | 1 | 31 |
|
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK_SalesTaxRate_SalesTaxRateID |
|
MS_Description | Primary key (clustered) constraint |
| Name |
|---|
| SalesTaxRateID |
| Name | Referenced Object | Update Action | Delete Action |
|---|---|---|---|
| FK_SalesTaxRate_StateProvince_StateProvinceID | Person.StateProvince | No action | No action |
| Name | Column ID | Column | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named |
|---|---|---|---|---|---|---|---|---|
| CK_SalesTaxRate_TaxType | 3 | TaxType | ([TaxType]>=(1) AND [TaxType]<=(3)) |
|
|
|
|
|
| Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|
| DF_SalesTaxRate_TaxRate | TaxRate | ((0.00)) |
|
MS_Description | Default constraint value of 0.0 |
| DF_SalesTaxRate_rowguid | rowguid | (newid()) |
|
MS_Description | Default constraint value of NEWID() |
| DF_SalesTaxRate_ModifiedDate | ModifiedDate | (getdate()) |
|
MS_Description | Default constraint value of GETDATE() |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK_SalesTaxRate_SalesTaxRateID | CLUSTERED |
|
|
|
|
|
| AK_SalesTaxRate_StateProvinceID_TaxType | NONCLUSTERED |
|
|
|
|
|
| AK_SalesTaxRate_rowguid | NONCLUSTERED |
|
|
|
|
|
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| PK_SalesTaxRate_SalesTaxRateID | Aug 8 2010 5:23PM | 29 | 29 | 16 | 1 | 4 |
|
29 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.03448276 | 4 | SalesTaxRateID |
| 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 |
| 16 | 0 | 1 | 0 | 1 |
| 18 | 1 | 1 | 1 | 1 |
| 20 | 1 | 1 | 1 | 1 |
| 22 | 1 | 1 | 1 | 1 |
| 24 | 1 | 1 | 1 | 1 |
| 26 | 1 | 1 | 1 | 1 |
| 28 | 1 | 1 | 1 | 1 |
| 30 | 1 | 1 | 1 | 1 |
| 31 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_SalesTaxRate_StateProvinceID_TaxType | Aug 8 2010 5:23PM | 29 | 29 | 22 | 0.8 | 9 |
|
29 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.03846154 | 4 | StateProvinceID |
| 0.03448276 | 5 | StateProvinceID, TaxType |
| 0.03448276 | 9 | StateProvinceID, TaxType, SalesTaxRateID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 1 | 0 | 2 | 0 | 1 |
| 6 | 0 | 1 | 0 | 1 |
| 7 | 0 | 1 | 0 | 1 |
| 9 | 0 | 1 | 0 | 1 |
| 14 | 0 | 1 | 0 | 1 |
| 15 | 0 | 1 | 0 | 1 |
| 20 | 0 | 1 | 0 | 1 |
| 29 | 0 | 1 | 0 | 1 |
| 31 | 1 | 1 | 1 | 1 |
| 35 | 0 | 1 | 0 | 1 |
| 36 | 0 | 1 | 0 | 1 |
| 41 | 0 | 1 | 0 | 1 |
| 49 | 1 | 1 | 1 | 1 |
| 51 | 0 | 1 | 0 | 1 |
| 63 | 2 | 2 | 1 | 2 |
| 69 | 0 | 1 | 0 | 1 |
| 72 | 0 | 1 | 0 | 1 |
| 74 | 1 | 1 | 1 | 1 |
| 77 | 0 | 1 | 0 | 1 |
| 79 | 0 | 1 | 0 | 1 |
| 83 | 0 | 1 | 0 | 1 |
| 84 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_SalesTaxRate_rowguid | Aug 8 2010 5:23PM | 29 | 29 | 28 | 1 | 20 |
|
29 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.03448276 | 16 | rowguid |
| 0.03448276 | 20 | rowguid, SalesTaxRateID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 90e3090e-df71-407a-8059-04c3104523af | 0 | 1 | 0 | 1 |
| 683de5dd-521a-47d4-a573-06a3cdb1bc5d | 1 | 1 | 1 | 1 |
| fb7607ee-8f12-41ea-b461-10885c6f1533 | 0 | 1 | 0 | 1 |
| d50102e1-0150-43f3-93ad-12ab6c1deb06 | 0 | 1 | 0 | 1 |
| 8451909f-8a8d-4789-9f87-16a335d28053 | 0 | 1 | 0 | 1 |
| f0d76907-b433-453f-b95e-16fce73b807a | 0 | 1 | 0 | 1 |
| f4fde24b-7a53-4340-9d10-173e9424864a | 0 | 1 | 0 | 1 |
| 89d447a8-239a-4f31-a529-478821e8f714 | 0 | 1 | 0 | 1 |
| d4edb557-56d7-403c-b538-4df5e7302588 | 0 | 1 | 0 | 1 |
| 9c84c0af-41cd-4670-98bc-5026e188541f | 0 | 1 | 0 | 1 |
| 1753d75f-8357-4497-bc92-543f17bbf514 | 0 | 1 | 0 | 1 |
| 5e6d8621-36af-40ce-972b-61aaef0556d8 | 0 | 1 | 0 | 1 |
| 630ae36f-6e76-4a1f-ab25-6342159c80d2 | 0 | 1 | 0 | 1 |
| abd185a9-5367-44e1-8a6e-71d083943f3c | 0 | 1 | 0 | 1 |
| 1e285d2c-8af7-47aa-b06a-762cf4d93acd | 0 | 1 | 0 | 1 |
| 3847b431-f939-4e89-83fc-864912e3cfd2 | 0 | 1 | 0 | 1 |
| 89dd0e3a-c018-449e-a86b-885adf684c5c | 0 | 1 | 0 | 1 |
| 06df529d-eb11-446f-9570-9ee97b8ea1bf | 0 | 1 | 0 | 1 |
| 207c7024-85fe-42cb-bf74-9fe88e2f4e1b | 0 | 1 | 0 | 1 |
| 5446ea04-fa7c-4b02-a157-a05f44bf47b6 | 0 | 1 | 0 | 1 |
| 383d465b-e1d1-492a-83f3-ab3e9cbf3282 | 0 | 1 | 0 | 1 |
| f9d1a85d-6474-43b5-a7ea-bed59e00439a | 0 | 1 | 0 | 1 |
| ecba1bab-a7a6-4cc2-8d0f-c094a38e5c0e | 0 | 1 | 0 | 1 |
| f53b6a7e-7da4-49e8-ac09-d57fefac64d3 | 0 | 1 | 0 | 1 |
| 590ccb14-cb20-49bf-8fee-e0c3abc4c2b1 | 0 | 1 | 0 | 1 |
| 78c8a559-4d0f-45b6-b7a3-e11ff9a702f4 | 0 | 1 | 0 | 1 |
| a8365f30-78b7-4dbe-8985-f8260560126b | 0 | 1 | 0 | 1 |
| 05c4ffdb-4f84-4cdf-abe5-fdf3216ea74e | 0 | 1 | 0 | 1 |
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Sales].[SalesTaxRate]( [SalesTaxRateID] [int] IDENTITY(1,1) NOT NULL, [StateProvinceID] [int] NOT NULL, [TaxType] [tinyint] NOT NULL, [TaxRate] [smallmoney] 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 SalesTaxRate records.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTaxRate', @level2type=N'COLUMN',@level2name=N'SalesTaxRateID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'State, province, or country/region the sales tax applies to.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTaxRate', @level2type=N'COLUMN',@level2name=N'StateProvinceID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTaxRate', @level2type=N'COLUMN',@level2name=N'TaxType' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Tax rate amount.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTaxRate', @level2type=N'COLUMN',@level2name=N'TaxRate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Tax rate description.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTaxRate', @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'Sales', @level1type=N'TABLE',@level1name=N'SalesTaxRate', @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'Sales', @level1type=N'TABLE',@level1name=N'SalesTaxRate', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Tax rate lookup table.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTaxRate' |