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 vote345 views1 answer
Sql query row number group by
SQL
24 votes395 views6 answers
Alter table name sql
SQL
21 votes368 views4 answers
Add column mssql
SQL
1 vote364 views1 answer
Cross schema query oracle 2 users
SQL
-2 votes340 views1 answer
Create trigger syntax
SQL
0 vote333 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote337 views1 answer
Disableforiegn key check
SQL
1 vote409 views2 answers
Install sql server management studio ubuntu
SQL
49 votes399 views6 answers
Get duplicate records in sql
SQL
1 vote346 views1 answer
Sql server 2016 reseed identity
SQL