Tables [dbo].[CPMaster]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)11
Created4:57:09 PM Thursday, September 7, 2006
Last Modified7:42:32 PM Wednesday, February 28, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_CPMaster: CPPriKeyCPPriKeyint4
No
1 - 1
Indexes IX_CPMaster_Description: DescriptionDescriptionvarchar(30)30
No
Foreign Keys FK_CPMaster_DateBasis: [dbo].[DateBasis].DateBasisFIDDateBasisFIDint4
No
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_CPMaster: CPPriKeyPK_CPMasterCPPriKey
Yes
80
IX_CPMaster_DescriptionDescription
Yes
Foreign Keys Foreign Keys
NameColumns
FK_CPMaster_DateBasisDateBasisFID->[dbo].[DateBasis].[DateBasisID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[CPMaster]
(
[CPPriKey] [int] NOT NULL IDENTITY(1, 1),
[Description] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DateBasisFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CPMaster] ADD CONSTRAINT [PK_CPMaster] PRIMARY KEY CLUSTERED  ([CPPriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CPMaster] ADD CONSTRAINT [IX_CPMaster_Description] UNIQUE NONCLUSTERED  ([Description]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CPMaster] ADD CONSTRAINT [FK_CPMaster_DateBasis] FOREIGN KEY ([DateBasisFID]) REFERENCES [dbo].[DateBasis] ([DateBasisID])
GO
GRANT SELECT ON  [dbo].[CPMaster] TO [MssExec]
GRANT INSERT ON  [dbo].[CPMaster] TO [MssExec]
GRANT DELETE ON  [dbo].[CPMaster] TO [MssExec]
GRANT UPDATE ON  [dbo].[CPMaster] TO [MssExec]
GO
Uses
Used By