[dbo].[LocationType]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count (~)	2
Created	10:56:42 AM Monday, May 4, 2015
Last Modified	10:56:42 AM Monday, May 4, 2015

	Name	Data Type	Max Length (Bytes)	Allow Nulls	Identity
	LocationTypeID	int	4		1 - 1
	Description	varchar(32)	32

	Name	Columns	Unique
	PK_LocationType	LocationTypeID

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

CREATE TABLE [dbo].[LocationType]
(
[LocationTypeID] [int] NOT NULL IDENTITY(1, 1),
[Description] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LocationType] ADD CONSTRAINT [PK_LocationType] PRIMARY KEY NONCLUSTERED  ([LocationTypeID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[LocationType] TO [MssExec]
GRANT INSERT ON  [dbo].[LocationType] TO [MssExec]
GRANT DELETE ON  [dbo].[LocationType] TO [MssExec]
GRANT UPDATE ON  [dbo].[LocationType] TO [MssExec]
GO