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

0 vote120 views1 answer
Sql select first and last record of each group
SQL
0 vote116 views4 answers
Open mysql port bitnami tomact
SQL
0 vote138 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote105 views1 answer
Sql drop default
SQL
33 votes96 views2 answers
Postgres how to add field created at
SQL
1 vote98 views1 answer
Sql headers delphi
SQL
0 vote93 views2 answers
Add new column after in sql
SQL
3 votes103 views2 answers
Postgresql remove not null constraint
SQL
0 vote68 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote93 views1 answer
Query on date sqlite flutter
SQL