Add field to existing table in PCC

[zemp]

Can I add a field to an existing table in the Pervasive Control Center? So far i have been unable to find a way to do this. I have too much data in the table to recreate it from scratch.

Or is there a way I could export and then import the data via the PCC?

Thanks and Good Luck!

zemp

 

[zemp]

Found what I was looking for.

"Alter table Table1 add column Colx VARCHAR(60)"

Thanks and Good Luck!

zemp

 

[mirtheil]

You could also have used the Table Designer to add the field.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician