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 vote144 views1 answer
Postgres count string length
SQL
28 votes134 views4 answers
Show tables mysql
SQL
2 votes144 views1 answer
Oracle to_char number format percentage
SQL
0 vote144 views1 answer
How to use lower case in mysql
SQL
0 vote118 views1 answer
Mariadb set vertical output format
SQL
2 votes139 views1 answer
Sql ignore accents
SQL
0 vote135 views1 answer
Sql case sttement with set
SQL
4 votes198 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
1 vote138 views1 answer
Sql run multiple updates in one query
SQL
0 vote255 views1 answer
Install mysql on bash
SQL