Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change field name programatically?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00411421
Message ID:
00411433
Views:
11
But even with the listed limitations, ALTER TABLE is still a cool function to use on free tables.

>ALTER TABLE [RENAME COLUMN FieldName4 TO FieldName5]
>
>ALTER TABLE can be used to modify the structure of a table that has not been added to a database. However, Visual FoxPro generates an error if you include the DEFAULT, FOREIGN KEY, PRIMARY KEY, REFERENCES, or SET clauses when modifying a free table.
Michael Helms

May the Schwartz be with you.<(©¿©)> -- Mel Brooks
"Someday, and that day may never come, you will be called upon to perform a service" -- Vito Corleone
"Live like there is no tomorrow, Dance like no one is watching, Love like you've never been hurt." -- Anonymous
"I'm thinking about joining the campaign for shorter tag lines." -- Me
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform