alter table

[Former Member]

Hi all,

I've been added two extra fileds ( text1 and text2 ) to ztable and activated. table was activated. but later on i've changed text1 type as 'date' from char.

Now table is not activating and getting error like 'Alter table is not possible!!'

could any please suggest me in this regard..

thanks and regards

[Former Member]

Hi Abdul,

Delete the full line and try it once.

Thanks.

[former_member588853]

Hi,

goto se11--> your table name > utilities> databse utility ->Activate and Adjust database..

reward if useful

regards,

nazeer

[Former Member]

delete the whole field and add again

also make sure that adjust/activate the table in SE14

[Former Member]

Hi,

Go to SE14. Give yr table name and edit. There click on activate and adjust database. Now ur prob will be solved.

Reward points if useful.

Regards,

U. Uma

[Former Member]

Hi

1. select the field which you want to change and then delete.

2. on the top of the fields table control u find insert button click on it.

3. create new field which u want to.

regards,

Lakshmikanth

[former_member196299]

Hi Abdul,

Why dont u delete the field and try creating it once more .

Do activate the table once you are done ...

Thanks

Ranjita