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 vote328 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote333 views1 answer
Sintaxis SELECT sql
SQL
0 vote308 views1 answer
Select value from previous row in postgresql
SQL
21 votes329 views4 answers
Add column mssql
SQL
0 vote338 views1 answer
Oracle drop type
SQL
0 vote326 views1 answer
Rename view mysql
SQL
1 vote319 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote359 views2 answers
Coursera spark sql max count
SQL
4 votes324 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote322 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL