Tables [dbo].[Stores]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)241
Created4:57:08 PM Thursday, September 7, 2006
Last Modified11:13:43 AM Monday, August 19, 2013
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_Stores: StoreIDStoreIDint4
No
1 - 1
StoreNamevarchar(50)50
No
StoreNovarchar(10)10
Yes
StoreLocationvarchar(50)50
Yes
StoreContactvarchar(50)50
Yes
RegManagerNamevarchar(50)50
Yes
DockmanagerNamevarchar(50)50
Yes
StoreManagerNamevarchar(50)50
Yes
VisualManagerNamevarchar(50)50
Yes
Elevatorvarchar(1)1
Yes
Escalatorvarchar(1)1
Yes
UnionDrivervarchar(1)1
Yes
UnionLaborvarchar(1)1
Yes
UnionNamevarchar(50)50
Yes
DockRestrictionsvarchar(30)30
Yes
Inactivesmallint2
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_Stores: StoreIDPK_StoresStoreID
Yes
80
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[Stores]
(
[StoreID] [int] NOT NULL IDENTITY(1, 1),
[StoreName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StoreNo] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StoreLocation] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StoreContact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RegManagerName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DockmanagerName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StoreManagerName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VisualManagerName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Elevator] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Escalator] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UnionDriver] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UnionLabor] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UnionName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DockRestrictions] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Inactive] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Stores] ADD CONSTRAINT [PK_Stores] PRIMARY KEY CLUSTERED  ([StoreID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[Stores] TO [MssExec]
GRANT INSERT ON  [dbo].[Stores] TO [MssExec]
GRANT DELETE ON  [dbo].[Stores] TO [MssExec]
GRANT UPDATE ON  [dbo].[Stores] TO [MssExec]
GO
Uses
Used By