Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. SELECT a.COLUMN_NAME
  2. FROM all_cons_columns a INNER JOIN all_constraints c
  3. ON a.constraint_name = c.constraint_name
  4. WHERE c.table_name = 'TBL'
  5. AND c.constraint_type = 'P';
  6.  
  7. SELECT X.NAME AS INDEXNAME,
  8. COL_NAME(IC.OBJECT_ID,IC.COLUMN_ID) AS COLUMNNAME
  9. FROM SYS.INDEXES X
  10. INNER JOIN SYS.INDEX_COLUMNS IC
  11. ON X.OBJECT_ID = IC.OBJECT_ID
  12. AND X.INDEX_ID = IC.INDEX_ID
  13. WHERE X.IS_PRIMARY_KEY = 1
  14. AND OBJECT_NAME(IC.OBJECT_ID)='YOUR_TABLE'
  15.  
  16. show index from TABLE where Key_name = 'PRIMARY' ;
  17.  
  18. SELECT k.COLUMN_NAME
  19. FROM information_schema.table_constraints t
  20. LEFT JOIN information_schema.key_column_usage k
  21. USING(constraint_name,table_schema,table_name)
  22. WHERE t.constraint_type='PRIMARY KEY'
  23. AND t.table_schema=DATABASE()
  24. AND t.table_name='owalog';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement