topic Re: alter table in Application Development and Automation Discussions

alter table

Former Member — Wed, 25 Apr 2007 12:00:31 GMT

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

Re: alter table

Former Member — Wed, 25 Apr 2007 12:05:20 GMT

Hi Abdul,

Delete the full line and try it once.

Thanks.

Re: alter table

Former Member — Wed, 25 Apr 2007 12:08:25 GMT

Hi,

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

reward if useful

regards,

nazeer

Re: alter table

Former Member — Wed, 25 Apr 2007 12:08:59 GMT

delete the whole field and add again

also make sure that adjust/activate the table in SE14

Re: alter table

Former Member — Wed, 25 Apr 2007 12:10:02 GMT

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

Re: alter table

Former Member — Wed, 25 Apr 2007 12:10:19 GMT

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

Re: alter table

former_member196299 — Wed, 25 Apr 2007 12:11:31 GMT

Hi Abdul,

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

Do activate the table once you are done ...

Thanks

Ranjita