Tables [dbo].[MobileCrewTimeSentStatus]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count (~)3
Created9:13:39 AM Thursday, May 23, 2024
Last Modified9:13:39 AM Thursday, May 23, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Primary Key PK_MobileCrewTimeSentStatus: MobileCrewTimeSentStatusIDMobileCrewTimeSentStatusIDint4
No
1 - 1
Indexes IX_MobileCrewTimeSentStatus_Status: StatusStatusvarchar(16)16
Yes
Indexes Indexes
NameColumnsUnique
Primary Key PK_MobileCrewTimeSentStatus: MobileCrewTimeSentStatusIDPK_MobileCrewTimeSentStatusMobileCrewTimeSentStatusID
Yes
IX_MobileCrewTimeSentStatus_StatusStatus
Yes
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[MobileCrewTimeSentStatus]
(
[MobileCrewTimeSentStatusID] [int] NOT NULL IDENTITY(1, 1),
[Status] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MobileCrewTimeSentStatus] ADD CONSTRAINT [PK_MobileCrewTimeSentStatus] PRIMARY KEY NONCLUSTERED  ([MobileCrewTimeSentStatusID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MobileCrewTimeSentStatus] ADD CONSTRAINT [IX_MobileCrewTimeSentStatus_Status] UNIQUE NONCLUSTERED  ([Status]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[MobileCrewTimeSentStatus] TO [MssExec]
GRANT INSERT ON  [dbo].[MobileCrewTimeSentStatus] TO [MssExec]
GRANT DELETE ON  [dbo].[MobileCrewTimeSentStatus] TO [MssExec]
GRANT UPDATE ON  [dbo].[MobileCrewTimeSentStatus] TO [MssExec]
GO
Uses
Used By