Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I drop a table from a database?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00532853
Message ID:
00532892
Vues:
12
This message has been marked as the solution to the initial question of the thread.
>I have a database where I need to create tables and drop tables.
>I know how to create table in my database.
>
>open database MYData
>create table Mytable...
>
>But what is the command to drop the table from the database?
>I have a blank.

As usual, it depends.
If you want to drop it and erase the table's files at the same time,
DROP TABLE myTable

If you want to drop the table, but not erase the table's files,
REMOVE TABLE myTable
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform