CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]

by 
if not exists (select * from sysobjects where name="cars" and xtype="U")
    create table cars (
        Name varchar(64) not null
    )
go

The above will create a table called cars if the table does not already exist.

More Related Contents:

  1. Calculating distance between two points (Latitude, Longitude)
  2. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  3. T-SQL split string based on delimiter
  4. WHERE Clause vs ON when using JOIN
  5. Partition Function COUNT() OVER possible using DISTINCT
  6. Cannot use UPDATE with OUTPUT clause when a trigger is on the table
  7. CASE WHEN statement for ORDER BY clause
  8. How to get last 7 days data from current datetime to last 7 days in sql server
  9. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  10. Reference an alias elsewhere in the SELECT list
  11. Using IF ELSE statement based on Count to execute different Insert statements
  12. How to find out what is locking my tables?
  13. Passing dynamic order by in stored procedure
  14. Select SQL Server database size
  15. Check if table exists and if it doesn’t exist, create it in SQL Server 2008
  16. How do I find the data directory for a SQL Server instance?
  17. How to return default value from SQL query
  18. How to concatenate all columns in a select with SQL Server
  19. How to automatically generate unique id in SQL like UID12345678?
  20. How to update two tables in one statement in SQL Server 2005?
  21. Foreign Key to non-primary key
  22. Dynamic SQL – EXEC(@SQL) versus EXEC SP_EXECUTESQL(@SQL)
  23. Get all dates between two dates in SQL Server
  24. Solution for: Store update, insert, or delete statement affected an unexpected number of rows (0) [closed]
  25. SQL grouping by month and year
  26. “IN” clause limitation in Sql Server
  27. Meaning of square brackets [] in MS-SQL table designer? [duplicate]
  28. Count Returning blank instead of 0
  29. Backup a single table with its data from a database in sql server 2008
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment