T-sql check if data exists

if exists(select 1 from INFORMATION_SCHEMA.TABLES T 
              where T.TABLE_NAME = 'Bookings') 
begin
    drop table Bookings
end
GO

create table Bookings(
  FlightID    int identity(1, 1) primary key,
  TicketsMax    int not null,
  TicketsBooked int not null
)
GO

insert  Bookings(TicketsMax, TicketsBooked) select 1, 0
insert  Bookings(TicketsMax, TicketsBooked) select 2, 2
insert  Bookings(TicketsMax, TicketsBooked) select 3, 1
GO

select * from Bookings

Source: stackoverflow.com

Similar codes

1 vote298 views1 answer
PL SQL MODIFY COLUMN NME
SQL
1 vote292 views1 answer
Oracle add proxy
SQL
0 vote305 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote310 views1 answer
Delete duplicate rows
SQL
0 vote337 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote304 views1 answer
Intellij idea add mysql connector
SQL
0 vote310 views1 answer
Openquery join two tables
SQL
23 votes271 views6 answers
Create table sql
SQL
1 vote471 views1 answer
Postgres upgrade to superuser
SQL
0 vote313 views1 answer
Excel export from sql using python
SQL