Collections:
Drop an Existing Index in Oracle
How To Drop an Existing Index in Oracle?
✍: FYIcenter.com
If you don't need an existing index any more, you should delete it with the DROP INDEX statement. Here is an example SQL script:
CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL, birth_date DATE NOT NULL, social_number VARCHAR(80) UNIQUE NOT NULL); Table created. CREATE INDEX student_birth_date ON student(birth_date); Index created. SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'STUDENT'; INDEX_NAME TABLE_NAME UNIQUENES ----------------------- --------------------- --------- SYS_C004129 STUDENT UNIQUE SYS_C004130 STUDENT UNIQUE STUDENT_BIRTH_DATE STUDENT NONUNIQUE DROP INDEX STUDENT_BIRTH_DATE; Index dropped.
⇐ ALTER INDEX - Rename an Index in Oracle
2020-02-20, 1497🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...