Is it OK to always fire the create statements rather than checking them like

```
SELECT * FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_NAME = 'my_table_name' 

```

in SQL SERVER CE and C#.
Because irrespective of the approach, there is always a single query that will be fired. Isnt it ???

I am using trasaction for creating all tables. So, I am sure if there is one table present, then definitely all of them are created.

So if i use the same transaction, then the transaction will fail right at the very first create table statement: But is this good performance wise???