Skip to content

Instantly share code, notes, and snippets.

@ghitti

ghitti/isUniqueKey

Created January 31, 2020 14:16
Show Gist options
  • Save ghitti/d76f5585ff06352038b4114507b7ca02 to your computer and use it in GitHub Desktop.
Save ghitti/d76f5585ff06352038b4114507b7ca02 to your computer and use it in GitHub Desktop.
Download ZIP
Determine DDS described physical files with unique keys
Raw
isUniqueKey
-- Determine DDS described physical files with unique Keys
SELECT a.*
FROM QSYS2.SYSPARTITIONINDEXSTAT a
WHERE Table_Schema = 'yourSchema'
AND Index_Type = 'PHYSICAL'
AND UNIQUE = '0';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment