Answers for "check if table exists sql query"

t-sql test if table exists

IF (EXISTS (SELECT * 
                 FROM INFORMATION_SCHEMA.TABLES 
                 WHERE TABLE_SCHEMA = 'TheSchema' 
                 AND  TABLE_NAME = 'TheTable'))
BEGIN
    --Do Stuff
END

Posted by: Guest on March-05-2020

Code answers related to "check if table exists sql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "check if table exists sql query"

Code answers related to "check if table exists sql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "check if table exists sql query"

Code answers related to "check if table exists sql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us