I'm creating tables in SQL Server 2012 Management Studio using SQL, how do I make columns or columns with names that are already defined in SQL Server e.g User_ID
, User_Name
, I want to use these as fields in my tables
create table Ticket
(
Ticket_Id varchar(10) not null,
TicketType_Id varchar(3) not null,
Ticket_PurchaseDate DateTime null,
LottoDraw_Id int null,
User_Id int null,
Ticket_IsWinner bit null
Primary Key(Ticket_Id, TicketType_Id)
)