Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Check if table in SQL Server exists
Message
De
29/03/2020 11:55:17
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01673835
Message ID:
01673879
Vues:
45
J'aime (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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform