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 vote165 views6 answers
In sql
SQL
0 vote170 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote241 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote169 views1 answer
Soql user profile
SQL
0 vote173 views4 answers
Mysql select bottom 10 rows
SQL
0 vote177 views1 answer
Get a list of tables and the primary key
SQL
0 vote216 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
18 votes173 views3 answers
Mysql add column default value
SQL
4 votes176 views1 answer
Refresh postgres config
SQL
0 vote207 views1 answer
Typical max-connect-errors mysql
SQL