UPDATE VS4TUserBranch set TUsBTCmGAlias='CENTER' WHERE TUsBTCmGAlias='' or TUsBTCmGAlias is null
GO
ALTER TABLE VS4TUserBranch DROP CONSTRAINT IF EXISTS TUsBTUsrID
GO
DROP INDEX VS4TUserBranch.PrimaryKey
GO
ALTER TABLE VS4TUserBranch ALTER COLUMN
	TUsBTCmGAlias nvarchar(30) NOT NULL
GO
ALTER TABLE VS4TUserBranch ADD CONSTRAINT
	TUsBTUsrID PRIMARY KEY CLUSTERED 
	(
	TUsBTUsrID,
	TUsBTBraCode,
	TUsBTCmGAlias
	) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX PrimaryKey ON VS4TUserBranch
	(
	TUsBTUsrID,
	TUsBTBraCode,
	TUsBTCmGAlias
	) ON [PRIMARY]
GO
