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 vote174 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote172 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
1 vote220 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
1 vote172 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote163 views1 answer
Postgre admin slow
SQL
0 vote157 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote169 views1 answer
Oracle exchange partition
SQL
3 votes172 views1 answer
How to check schema privileges in oracle
SQL
4 votes185 views1 answer
Is there any command to change postgres password
SQL
10 votes163 views4 answers
Primary key in sql
SQL