Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

alter table

Former Member
0 Likes
898

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
862

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

6 REPLIES 6
Read only

Former Member
0 Likes
862

Hi Abdul,

Delete the full line and try it once.

Thanks.

Read only

Former Member
0 Likes
862

Hi,

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

reward if useful

regards,

nazeer

Read only

Former Member
0 Likes
862

delete the whole field and add again

also make sure that adjust/activate the table in SE14

Read only

Former Member
0 Likes
863

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

Read only

Former Member
0 Likes
862

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

Read only

former_member196299
Active Contributor
0 Likes
862

Hi Abdul,

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

Do activate the table once you are done ...

Thanks

Ranjita