Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Tuesday, September 18, 2012

How to drop a Primary Key

Alter table <Schema>.<Table> drop constraint <Name_of_Primary_ Key>  ;

How to switch to a different Schema

ALTER SESSION SET CURRENT_SCHEMA = <My_Schema>;