-- Change Back End Label Language
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Vs_FormLanguage
	(
	ID bigint NOT NULL IDENTITY (1, 1),
	SystemCode varchar(20) NULL,
	FormName varchar(20) NULL,
	LabelName varchar(20) NULL,
	LabelIndex int NULL,
	LabelCaption varchar(100) NULL,
	LabelCaption1 varchar(100) NULL,
	LabelCaption2 varchar(100) NULL,
	LabelCaption3 varchar(100) NULL,
	LabelCaption4 varchar(100) NULL,
	LabelCaption5 varchar(100) NULL,
	LabelCaption6 varchar(100) NULL,
	LabelCaption7 varchar(100) NULL,
	LabelCaption8 varchar(100) NULL,
	LabelCaption9 varchar(100) NULL,
	LabelCaption10 varchar(100) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Vs_FormLanguage ADD CONSTRAINT
	DF_Vs_FormLanguage_LabelIndex DEFAULT 0 FOR LabelIndex
GO
ALTER TABLE dbo.Vs_FormLanguage ADD CONSTRAINT
	PK_Vs_FormLanguage PRIMARY KEY CLUSTERED 
	(
	ID
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vs_FormLanguage', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vs_FormLanguage', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vs_FormLanguage', 'Object', 'CONTROL') as Contr_Per