Purchasing.ShipMethod Table

Information

Name	ShipMethod
Schema	Purchasing
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:55

Extended Properties

Name	Type	Property Name	Value
ShipMethod	TABLE	MS_Description	Shipping company lookup table.

Columns

Name	Data Type	Collation	Default
ShipMethodID	int
Name	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
ShipBase	money		((0.00))
ShipRate	money		((0.00))
rowguid	uniqueidentifier		(newid())
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Columns
PK_ShipMethod_ShipMethodID	Clustered	ShipMethodID
AK_ShipMethod_Name	NonClustered	Name
AK_ShipMethod_rowguid	NonClustered	rowguid

Check Constraints

Name	Column	Enabled	Trusted	Expression
CK_ShipMethod_ShipBase	ShipBase			([ShipBase]>(0.00))
CK_ShipMethod_ShipRate	ShipRate			([ShipRate]>(0.00))

SQL Script

CREATE TABLE [Purchasing].[ShipMethod] (
    [ShipMethodID] int NOT NULL IDENTITY,
    [Name] nvarchar(50) NOT NULL,
    [ShipBase] money NOT NULL DEFAULT ((0.00)),
    [ShipRate] money NOT NULL DEFAULT ((0.00)),
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_ShipMethod_Name] on [Purchasing].[ShipMethod]([Name]);
CREATE UNIQUE INDEX [AK_ShipMethod_rowguid] on [Purchasing].[ShipMethod]([rowguid]);