http://www.bing.com:80/search?q=Create+Table+If+Not+Exists+SQLSearch resultshttp://www.bing.com:80/s/a/rsslogo.gifhttp://www.bing.com:80/search?q=Create+Table+If+Not+Exists+SQLCopyright © 2026 Microsoft. All rights reserved. These XML results may not be used, reproduced or transmitted in any manner or for any purpose other than rendering Bing results within an RSS aggregator for your personal, non-commercial use. Any other use of these results requires express written permission from Microsoft Corporation. By accessing this web page or using these results in any manner whatsoever, you agree to be bound by the foregoing restrictions.https://stackoverflow.com/questions/5952006/check-if-table-exists-and-if-it-doesnt-exist-create-it-in-sql-server-2008I am writing a Stored procedure in SQL Server 2008. I need to check if a table exists in the database. If it doesn't then I need to create it. How do I do this?Mon, 13 Apr 2026 16:10:00 GMThttps://stackoverflow.com/questions/6520999/create-table-if-not-exists-equivalent-in-sql-serverCREATE TABLE IF NOT EXISTS works on mysql but fails with SQL Server 2008 R2. What is the equivalent syntax?Fri, 17 Apr 2026 02:22:00 GMThttps://stackoverflow.com/questions/167576/check-if-table-exists-in-sql-serverI would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 using SQL Statements. Here are two possible ways of doing it. Which one is the standard/bes...Sat, 18 Apr 2026 19:03:00 GMThttps://stackoverflow.com/questions/1650946/mysql-create-table-if-not-exists-error-1050Using the command: CREATE TABLE IF NOT EXISTS `test`.`t1` ( `col` VARCHAR(16) NOT NULL ) ENGINE=MEMORY; Running this twice in the MySQL Query Browser results in: Table 't1' already exists Er...Wed, 15 Apr 2026 00:51:00 GMThttps://stackoverflow.com/questions/15630771/check-table-exist-or-not-before-create-it-in-oracleTrying to check is table exist before create in Oracle. Search for most of the post from Stackoverflow and others too. Find some query but it didn't work for me. IF((SELECT count(*) FROM dba_tablesTue, 14 Apr 2026 20:40:00 GMThttps://stackoverflow.com/questions/70471176/oracle-19c-create-table-if-not-existsThat's not valid syntax in Oracle. Here, you have to manually check whether table exists or not and then create it (or not). Exception you mentioned means that they used PL/SQL (not SQL). We normally create tables in SQL. If you must use PL/SQL, then - as CREATE TABLE is DDL - you have to use dynamic SQL which is difficult to maintain and debug. Therefore, if you just don't care whether table ...Thu, 16 Apr 2026 20:24:00 GMThttps://stackoverflow.com/questions/16837134/alter-table-if-exists-or-create-if-doesntThe SQL script creates tables, however, if there are already tables in the database, it should apply changes. In this version, it only works if there are additional columns.Sun, 19 Apr 2026 20:49:00 GMThttps://stackoverflow.com/questions/42560077/sql-server-check-if-table-exists-otherwise-create-itIf i drop schema part - and use this - it appears to work: IF (NOT ( EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'odds_soccer') )) Since this is actually code generated by software with no particular knowledge about the underlying DB (odds_soccer is just an example, could be whatever data, columns etc.) ---- would this not be the most compatible code to generate/use?Fri, 17 Apr 2026 21:13:00 GMThttps://stackoverflow.com/questions/42511328/sql-server-create-temp-table-if-doesnt-existThere is already an object named '#MyTable' in the database So it seems it doesn't simply ignore those lines within the If statement. Is there a way to accomplish this - create a temp table if it doesn't already exist, otherwise, use the one already in memory? Thanks! UPDATE:Thu, 16 Apr 2026 19:12:00 GMThttps://pt.stackoverflow.com/questions/363098/cria%c3%a7%c3%a3o-de-um-banco-de-dados-simples-com-o-not-existsQuando eu coloco este código para executar no MySQL, a primeira linha é executada sem nenhuma exceção, mas na segunda linha, o programa reconhece um erro lógico falando que a tabela tb_aluno já existe. Dentro do console aparece um código de erro de nº 1050. Para resolver este problema, coloquei o IF NOT EXISTS junto do CREATE TABLE para eliminar o erro 1050 e criar uma tabela já ...Sat, 18 Apr 2026 04:01:00 GMT