Change of structure of database table

[Former Member]

A custom database table has been created and is already in use by 10 programs. Now a new requirement has come to add a field i.e. a check box to the database table to be used by one of the 10 programs. Can we change the structure of the database table after activating it and when the table is in use? Please provide me inputs on this.

Thanks and regards

Radhika

[Former Member]

Yes. U can change it. But I suggest u to do it through the process of 'Append Structure'.

If u have any probelm after changing follow this process.

Goto Utilities > Database Utilities> Activate and Adjust Database

Awrd Points if useful

Bhupal

[former_member873340]

Radhika,

If your field is not a key field then u can simply add it without any effect....

But appending the structure is the best approach to adding the fields to already existing table which is being used by programs.......

Regards

Gowri