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 vote173 views1 answer
Oracle compile schema
SQL
11 votes250 views1 answer
How to get ddl for materialized view
SQL
0 vote201 views3 answers
Get free card roblox
SQL
2 votes194 views1 answer
Sqlite show table indexes
SQL
0 vote172 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote201 views2 answers
Psql commande \gset
SQL
-3 votes197 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
6 votes210 views3 answers
Sql select last id
SQL
0 vote207 views1 answer
How to delete python anywhere mysql database
SQL
0 vote231 views1 answer
Returning with sqlalchemy
SQL