Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Drop an Index
How To Drop an Index? - Oracle DBA FAQ - Understanding SQL DDL Statements
✍: 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.
2007-04-22, 4638👍, 0💬
Popular Posts:
Can include files be nested? The answer is yes. Include files can be nested any number of times. As ...
.NET INTERVIEW QUESTIONS - What is Suspend and Resume in Threading ? It is Similar to Sleep and Inte...
Can two catch blocks be executed? No, once the proper catch section is executed the control goes fin...
WHat will be the result of the following code? #define TRUE 0 // some code while (TRUE) { // some co...
Describe different elements in Static Chart diagrams ? Package: - It logically groups element of a U...