· 8 years ago · Mar 07, 2018, 11:46 AM
1SET ANSI_NULLS OFF
2GO
3SET QUOTED_IDENTIFIER ON
4GO
5IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[deleted]') AND type in (N'U'))
6BEGIN
7CREATE TABLE [dbo].[deleted](
8 [id] [int] NOT NULL,
9 [StudentID] [int] NOT NULL,
10 [FirstName] [varchar](150) NOT NULL,
11 [MiddleName] [varchar](150) NOT NULL,
12 [LastName] [varchar](150) NOT NULL,
13 [CreatedAt] [int] NOT NULL,
14 [CreatedBy] [varchar](100) NOT NULL,
15 [UpdatedAt] [int] NOT NULL,
16 [UpdatedBy] [varchar](100) NOT NULL,
17 [ClubID] [int] NOT NULL,
18 [currentRank] [varchar](15) NOT NULL,
19 [transfer_id] [varchar](50) NOT NULL
20) ON [PRIMARY]
21END