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 vote237 views1 answer
Mysql #1064 error
SQL
4 votes249 views2 answers
Truncate oracle
SQL
0 vote249 views1 answer
Select multiple row from primary key sql
SQL
0 vote237 views1 answer
What is SQL data store?
SQL
2 votes248 views1 answer
Oracle list duplicates
SQL
0 vote246 views2 answers
Reseed sql identity
SQL
-2 votes233 views1 answer
Mysql see users and passwords
SQL
-1 vote230 views1 answer
Mysql coalesce
SQL
0 vote227 views1 answer
Mysql remove tabs from string
SQL
4 votes257 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL