Rearrange order of fields in a sql table

Asked Feb 17 '13 at 11:40

Active Feb 17 '13 at 12:01

Viewed 93 times

My aim is to alter table course_info whose present schema is

course_info( course_no , course_name , course_prerequisite , cost )

into

course_info( course_no , course_prerequisite , course_name , cost )

I tried the sql statement as per the link How to move columns in a MySQL table?

Statement throwing error:

alter table course_info modify course_prerequisite number(8) after course_name ; but it is giving me error

ORA-01735: invalid ALTER TABLE option

edited May 23 '17 at 12:27

Community

asked Feb 17 '13 at 11:40

ekansh919

1

Please format the code – DevelopmentIsMyPassion Feb 17 '13 at 11:42
2

Why do you want to do that exactly? – Mat Feb 17 '13 at 11:42
@Mat my input data .sql file has different order in entries so when i run that file it throws me error , thats why i am trying to rearrange the fields of my table – ekansh919 Feb 17 '13 at 11:57
Well you'll have to re-create your table or use `dbms_redefinition`, or modify your .sql file. – Mat Feb 17 '13 at 11:59
2

If the input sql file has a different order, why don't you change that? – Dan Bracuk Feb 17 '13 at 12:10
@Mat thanks that post will work . – ekansh919 Feb 17 '13 at 12:19
`create table course_info_dup as select course_no,course_prerequisite , course_name , cost from course_info;` and then drop the course_info table then rename course_info_dup to course_info – Aspirant Feb 18 '13 at 05:30

0 Answers0