drop table

[revsmettukuru]

Hey GUYS,

I want to drop a table from another schema.I am using the same database but different schemas.
Can anyone send me a query fro that.

Thanks,
Sree

[chella]

Hi Sree,

To drop a table in another schema you need to prefix the schema name with the table name
drop table schemaname.tabl ename

The important thing you need to note is that, inorder to drop a table in another schema(for which you are not the owner) you need to have DROP ANY TABLE system privilage.

Hope the above information helps you.

Regards,
Chella

[debasisdas]

to drop table of naother user

1. you must be a administrator OR
2. must have DROP ANY TABLE privilages OR
3.must be granted ALL on that table by the owner of the table / admin.

To drop u need to specify the fully qualified name of the table
i.e.
schemaname.tabl ename