Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
ALTER TABLE <table_name> ADD CONSTRAINT <primary_key_constraint_name> PRIMARY KEY (<column_name>) USING INDEX
ALTER TABLE <tablename> DROP PRIMARY KEY
SELECT * FROM user_ind_columns WHERE table_name='<tablename>' ORDER BY index_name, column_position
SELECT * FROM user_constraints WHERE table_name = '<tablename>'
SELECT * FROM user_cons_columns WHERE table_name = '<tablename>'
Remember Me
a@href@title, b, blockquote@cite, em, i, strike, strong, sub, super, u