Public Synonym

hi all,

COuld anybody tell me pls. how to drop the PUBLIC synonym in oracle 8i.. syntax pls...

Thanks...

:confused:

MH

I don't think you can drop that, mate.

Ummmm.....

Not unless you wanted to type:

drop public synonym [user.]synonym_name :rolleyes:

Quote:

---

Originally posted by BirdRacer
Ummmm.....

Not unless you wanted to type:

drop public synonym [user.]synonym_name :rolleyes:

---

Ummm.....

Don't know what you mean by that (optional) "USER." part. Public synonym is public, meaning no user realy owns it. So if you try to stick that "user." part in the syntax, you defenitely won't be able to drop public synonym..... So it's just

Code:

---

drop public synonym synonym_name;

---

:rolleyes: