Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Check if table in SQL Server exists
Message
From
29/03/2020 11:55:17
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01673835
Message ID:
01673879
Views:
46
Likes (1)
>I need to check (from a VFP 9 application) if a table in the SQL Server DB exists. I found a pretty simple code in one of the online threads. The code is as follows:

UPDATE: UGH: my fault.....I didn't realize you were talking about VFP....my fault....I'd delete my answer but I don't think I can delete a post. Sorry about that.

Which version of SQL Server are you using?

For instance, there's an IF EXISTS that's tied to the DROP TABLE statement in SQL 2016

DROP TABLE IF EXISTS dbo.MyTable
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform