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

3 votes365 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
1 vote199 views1 answer
Delete specific row in sql
SQL
1 vote228 views1 answer
Find difference in dates sql
SQL
5 votes201 views2 answers
To date oracle
SQL
1 vote232 views1 answer
Mysql select update same table
SQL
7 votes196 views4 answers
Index in mysql
SQL
0 vote188 views1 answer
Create new schema mysql
SQL
2 votes208 views2 answers
Install sqlalchemy
SQL
1 vote197 views1 answer
Select not matching data from two tables
SQL
0 vote189 views1 answer
Select last 2 characters sql
SQL