| View previous topic :: View next topic |
| Author |
Message |
Alexandre César Guest
|
Posted: Fri Aug 18, 2006 7:46 pm Post subject: How to reestructure one BDE table in trough application? |
|
|
How to reestruture one BDE table from my application using BDE functions?
I need include one field in a table wich has data!
This is possible and secure?
Thank's |
|
| Back to top |
|
 |
Antonio Felix Guest
|
Posted: Fri Aug 18, 2006 8:46 pm Post subject: Re: How to reestructure one BDE table in trough application? |
|
|
"Alexandre César" <alexandrecrt (AT) gmail (DOT) com> wrote:
| Quote: | How to reestruture one BDE table from my application using BDE functions?
I need include one field in a table wich has data!
This is possible and secure?
Thank's
|
Hi,
The easiest way is to use the ALTER TABLE DML statement
/quote
Adds or deletes a column from a table.
ALTER TABLE table_reference DROP [COLUMN] column_reference | ADD [COLUMN] column_reference [,reference DROP [COLUMN] column_reference | ADD [COLUMN] column_reference...]
/endquote
HTH
Antonio |
|
| Back to top |
|
 |
Antonio Felix Guest
|
|
| Back to top |
|
 |
|