drop table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • revsmettukuru
    New Member
    • Sep 2007
    • 1

    drop table

    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
    New Member
    • Mar 2007
    • 51

    #2
    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

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      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

      Comment

      Working...