[dbo].[SUDFMoveTypeLabels]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	0
Created	10:06:10 AM Friday, December 7, 2018
Last Modified	10:06:28 AM Friday, December 7, 2018

Name	Data Type	Max Length (Bytes)
MoveTypePriKey	int	4
UserDefinedLabel1	varchar(30)	30
UserDefinedLabel2	varchar(30)	30
UserDefinedLabel3	varchar(30)	30
UserDefinedLabel4	varchar(30)	30
UserDefinedLabel5	varchar(30)	30
UserDefinedLabel6	varchar(30)	30
UserDefinedLabel7	varchar(30)	30
UserDefinedLabel8	varchar(30)	30

	Name	Columns	Unique
	PK_SUDFMoveTypeLabels	MoveTypePriKey

Name	Columns
FK_MoveTypePriKey_MoveType	MoveTypePriKey->[dbo].[MoveType].[PriKey]

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

SQL Script

CREATE TABLE [dbo].[SUDFMoveTypeLabels]
(
[MoveTypePriKey] [int] NOT NULL,
[UserDefinedLabel1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserDefinedLabel2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserDefinedLabel3] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserDefinedLabel4] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserDefinedLabel5] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserDefinedLabel6] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserDefinedLabel7] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserDefinedLabel8] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SUDFMoveTypeLabels] ADD CONSTRAINT [PK_SUDFMoveTypeLabels] PRIMARY KEY CLUSTERED  ([MoveTypePriKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SUDFMoveTypeLabels] ADD CONSTRAINT [FK_MoveTypePriKey_MoveType] FOREIGN KEY ([MoveTypePriKey]) REFERENCES [dbo].[MoveType] ([PriKey])
GO
GRANT SELECT ON  [dbo].[SUDFMoveTypeLabels] TO [MssExec]
GRANT INSERT ON  [dbo].[SUDFMoveTypeLabels] TO [MssExec]
GRANT DELETE ON  [dbo].[SUDFMoveTypeLabels] TO [MssExec]
GRANT UPDATE ON  [dbo].[SUDFMoveTypeLabels] TO [MssExec]
GO