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

10 votes335 views3 answers
How to fetch first 5 characters in sql
SQL
4 votes324 views2 answers
SELECT table_name FROM user_tables;
SQL
1 vote357 views5 answers
What is in operator in sql
SQL
13 votes342 views2 answers
Sql online compiler
SQL
0 vote309 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
14 votes351 views3 answers
Inner join sql oracle
SQL
0 vote343 views1 answer
Sql ignore
SQL
0 vote320 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote320 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote370 views1 answer
Create a view in sqlite
SQL