Check if table exists and if it doesn’t exist, create it in SQL Server 2008

by

Something like this

IF  NOT EXISTS (SELECT * FROM sys.objects 
WHERE object_id = OBJECT_ID(N'[dbo].[YourTable]') AND type in (N'U'))

BEGIN
CREATE TABLE [dbo].[YourTable](
    ....
    ....
    ....
) 

END

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. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  7. Using IF ELSE statement based on Count to execute different Insert statements
  8. How to create a specific SQL Server stored procedure? [closed]
  9. SQL Server dynamic PIVOT query?
  10. SQL Server – Best way to get identity of inserted row?
  11. Should I use != or for not equal in T-SQL?
  12. How to update two tables in one statement in SQL Server 2005?
  13. SQL Server Process Queue Race Condition
  14. Is the NOLOCK (Sql Server hint) bad practice?
  15. SQL – Subtracting a depleting value from rows
  16. OR is not supported with CASE Statement in SQL Server
  17. How to set variable from a SQL query?
  18. Compare DATETIME and DATE ignoring time portion
  19. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  20. SQL dot notation
  21. Split function in SQL Server 2008
  22. T-SQL How to create tables dynamically in stored procedures?
  23. What is the equivalent of ‘describe table’ in SQL Server?
  24. How can I group by date time column without taking time into consideration
  25. Update query using Subquery in Sql Server
  26. T-SQL: checking for email format
  27. SQL – How do I get only the numbers after the decimal?
  28. How to retrieve records for last 30 minutes in MS SQL?
  29. Group consecutive rows of same value using time spans
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment