Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Default Values
Message
De
08/10/2005 01:02:28
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Default Values
Divers
Thread ID:
01057391
Message ID:
01057391
Vues:
60
Hi Guys,

Is it possible to add a default value to an existing column in a SQL Table?
I've tried this but it does'nt work

ALTER TABLE Customer
ALTER COLUMN flag SET DEFAULT 1

Any idea?


Thanks in advance...
Music Rocks www.musicreserve.blogspot.com
Success is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform