Create Table with primary key and Auto Increment && Rename Column && update view model

 create table Slots

(

SlotId int primary key identity(1,1),

Slot Time,

UserId nvarchar(128)

);

EXEC sp_rename 'TableName.OldColumnName', 'NewColumnName', 'COLUMN';

CREATE OR ALTER VIEW dbo.PrevOrderUserInfo AS

SELECT 

    p.OrderId, p.UserId, p.EventName, p.EventDate, p.Location, p.Price,

    u.UserName, p.CreatedDate, u.Email, u.PhoneNumber,

    p.StandardName,p.PackageName, p.OfferName

FROM dbo.PrevOrders AS p

INNER JOIN dbo.UserInfo AS u ON p.UserId = u.UserId;