Sales.Store Table

Information

Name	Store
Schema	Sales
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:56

Extended Properties

Name	Type	Property Name	Value
Store	TABLE	MS_Description	Customers (resellers) of Adventure Works products.

Columns

Name	Data Type	Collation	References	Default
CustomerID	int		Sales.Customer.CustomerID
Name	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
SalesPersonID	int		Sales.SalesPerson.SalesPersonID
Demographics	xml
rowguid	uniqueidentifier			(newid())
ModifiedDate	datetime			(getdate())

Indexes

Name	Type	Columns
PK_Store_CustomerID	Clustered	CustomerID
AK_Store_rowguid	NonClustered	rowguid
IX_Store_SalesPersonID	NonClustered	SalesPersonID

Foreign Key Constraints

Name	Type	Referenced Table
FK_Store_Customer_CustomerID	Foreign key	Sales.Customer
FK_Store_SalesPerson_SalesPersonID	Foreign key	Sales.SalesPerson

Triggers

Name	Activates on	Instead Of	For Replication	Enabled	Created	Modified
iStore	INSERT				29.3.2010. 21:58:56	29.3.2010. 21:58:56

SQL Script

CREATE TABLE [Sales].[Store] (
    [CustomerID] int NOT NULL,
    [Name] nvarchar(50) NOT NULL,
    [SalesPersonID] int NULL,
    [Demographics] xml NULL,
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_Store_rowguid] on [Sales].[Store]([rowguid]);
CREATE INDEX [IX_Store_SalesPersonID] on [Sales].[Store]([SalesPersonID]);