alter table syntax

[sushjames]

hello experts,

i'm having a problem in this synatx

alter table <table name> drop column <column name>

alter tabel <table name> rename column <old column name> to <new column name>

actually this syntax aren't working in oracle 8i whether it will work in 9i ?. can anyone suggest me pls. and also can anyone tell me the difference between 8i and 9i?

[frozenmist]

Hi,
Its working in 9i.
Please check if it is a syntax problem or a problem with the column you are trying to drop. If there is a primary key , foreign key or any such constraints on that column error can be raised.

So try
alter table <table name> drop column <column name> CASCADE CONSTRAINTS;

Hope it is useful
Cheers

[sushjames]

hi frozenmist,

I had tried this syntax in oralce 8i but still it's not working. Are you sure that this syntax is working in oracle 9i bcoz if it's working in oracle 9i then i will upgrade my oracle 8i to 9i. Can you pls confirm it.. thanx in advance

[frozenmist]

Hi,
I am working on Oracle 9i and I have tired out the query. Its working fine.
So it should work.

Cheers

[sushjames]

Hi,
I am working on Oracle 9i and I have tired out the query. Its working fine.
So it should work.

Cheers

Thanx dude! and Can you tell me anything about OCP Exam?

[frozenmist]

No idea , i have never taken it.
May be some one else can help you.
Cheers.

[debasisdas]

dear sush

your syntax is right

to rename any column try the command on version 10g ,it may not work on earlier versions.