HmZWRRxS

1ALTER TABLE [dbo].[UserProfile] 
2ADD
3[FirstName] VARCHAR(150) NOT NULL,
4[LastName] VARCHAR(150) NOT NULL,
5[Email] VARCHAR(150) NOT NULL; 
6     
7...
8REFERENCES **[UserProfile]** ([UserId])
9... 
10     
11CREATE TABLE [dbo].[UserProfile] (
12  [FirstName] VARCHAR(150) NOT NULL,
13  [LastName] VARCHAR(150) NOT NULL,
14  [Email] VARCHAR(150) NOT NULL
15) 
16     
17IF NOT EXISTS (SELECT 1 FROM sys.tables WHERE [object_id] = OBJECT_ID(N'dbo.UserProfile', N'U'))
18BEGIN
19    CREATE TABLE [dbo].[UserProfile] (
20          [FirstName] VARCHAR(150) NOT NULL,
21          [LastName] VARCHAR(150) NOT NULL,
22          [Email] VARCHAR(150) NOT NULL
23        )
24END 
25     
26IF NOT EXISTS (SELECT 1 FROM sys.columns WHERE [name] = 'FirstName' AND [object_id] = OBJECT_ID(N'dbo.UserProfile', N'U'))
27BEGIN
28    ALTER TABLE dbo.UserProfile 
29        ADD [FirstName] VARCHAR(150) NOT NULL
30END
31
32IF NOT EXISTS (SELECT 1 FROM sys.columns WHERE [name] = 'LastName' AND [object_id] = OBJECT_ID(N'dbo.UserProfile', N'U'))
33BEGIN
34    ALTER TABLE dbo.UserProfile 
35        ADD LastName VARCHAR(150) NOT NULL
36END
37
38IF NOT EXISTS (SELECT 1 FROM sys.columns WHERE [name] = 'Email' AND [object_id] = OBJECT_ID(N'dbo.UserProfile', N'U'))
39BEGIN
40    ALTER TABLE dbo.UserProfile 
41        ADD Email VARCHAR(150) NOT NULL
42END