check all indexes on table
SELECT
tablename,
indexname,
indexdef
FROM
pg_indexes
WHERE
schemaname = 'yourschema' and tablename='yourtable'
ORDER BY
tablename,
indexname;
(POSTRGRESQL)
check all indexes on table
SELECT
tablename,
indexname,
indexdef
FROM
pg_indexes
WHERE
schemaname = 'yourschema' and tablename='yourtable'
ORDER BY
tablename,
indexname;
(POSTRGRESQL)
display index in sql
SHOW INDEX FROM yourtable;
sql view index
-- Oracle (all_indexes: depending on grants, dba_indexes: for all indexes))
SELECT index_name FROM user_indexes WHERE table_name = 'MY_TABLE';
-- List of indexed columns:
SELECT index_name, column_position, column_name
FROM user_ind_columns -- or all_ind_columns / dba_ind_columns
WHERE table_name = 'MY_TABLE'
ORDER BY index_name, column_order;
display index in sql
SELECT DISTINCT
TABLE_NAME,
INDEX_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = 'your_schema';
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us