Properties

Owner:	Sales
Creation Date:	04/26/2006
Located On:	PRIMARY
Data Size KB:	8
Index Size KB:	8
Rows:	10
Description:	Lookup table of customer purchase reasons.

Columns

		Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
		SalesReasonID	int	4					Primary key for SalesReason records.
		Name	Name	100					Sales reason description.
		ReasonType	Name	100					Category the sales reason belongs to.
		ModifiedDate	datetime	8		(getdate())			Date and time the record was last updated.

Total: 4 column(s)

Identity column

	Name	Seed	Increment	Not for replication
	SalesReasonID	1	1

Indexes

	Index	Primary	Unique	Description
	PK_SalesReason_SalesReasonID			Primary key (clustered) constraint

Total: 1 index(es)

Referencing Tables

	Table	Foreign Key	Primary Key or Unique Constraint
	Sales.SalesOrderHeaderSalesReason	FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID	PK_SalesReason_SalesReasonID

Total: 1 table(s)

Objects that [Sales].[SalesReason] depends on

	Object Name	Owner	Object Type	Dep Level
	Name	dbo	User Defined type	1

Total: 1 object(s)

Objects that depend on [Sales].[SalesReason]

	Object Name	Owner	Object Type	Dep Level
	SalesOrderHeaderSalesReason	Sales	Table	1

Total: 1 object(s)

SQL

CREATE TABLE [SalesReason] (
    [SalesReasonID] [int] IDENTITY (1, 1) NOT NULL ,
    [Name] [Name] NOT NULL ,
    [ReasonType] [Name] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_SalesReason_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_SalesReason_SalesReasonID] PRIMARY KEY  CLUSTERED
    (
        [SalesReasonID]
    )  ON [PRIMARY]
) ON [PRIMARY]
GO

See Also

List of tables