Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table names
Message
De
14/01/2002 15:31:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
14/01/2002 15:06:10
Scott Starkey
Tindall Record Storage
Fort Worth, Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00604532
Message ID:
00604546
Vues:
20
>I am going to create a program where a user can create their own tables, but I want to make sure that they don't name their table something that won't work. Is there a list of characters that can't be used in the names of tables? I am not using a database container, so do the tablenames have to be ten characters or less?
>
>Thanks in advance

Table name can be longer than 10 characters, must start with a letter or underscore, followed by a string of letters, underscores, digits.

Field and index names have the same rules, but field names have a maximum of 10 characters if you have no DBC, and index names have a maximum of 10 characters, even with a DBC.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform