Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Default Values
Message
From
08/10/2005 01:02:28
Mike Zapanta
Bizbox Inc.
Manila, Philippines
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Default Values
Miscellaneous
Thread ID:
01057391
Message ID:
01057391
Views:
58
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.
Next
Reply
Map
View

Click here to load this message in the networking platform