Collections:
Show All Indexes in Your Schema in Oracle
How To List All Indexes in Your Schema in Oracle?
✍: FYIcenter.com
If you log in with your Oracle account, and you want to get a list of all indexes in your schema, you can get it through the USER_INDEXES view with a SELECT statement, as shown in the following SQL script:
SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'EMPLOYEES'; INDEX_NAME TABLE_NAME UNIQUENES ----------------------- --------------------- --------- EMP_EMAIL_UK EMPLOYEES UNIQUE EMP_EMP_ID_PK EMPLOYEES UNIQUE EMP_DEPARTMENT_IX EMPLOYEES NONUNIQUE EMP_JOB_IX EMPLOYEES NONUNIQUE EMP_MANAGER_IX EMPLOYEES NONUNIQUE EMP_NAME_IX EMPLOYEES NONUNIQUE
As you can see, the pre-defined table EMPLOYEES has 6 indexes defined in the default sample database.
⇒ Indexes for the PRIMARY KEY Column in Oracle
⇐ Create a Table Index in Oracle
2019-05-01, 1644🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...