SQL•SQL References

SQL DROP INDEX Keyword

Concept visual

SQL DROP INDEX Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

DROP INDEX Keyword

Drop Index

The DROP INDEX

command is used to delete an index in a table.

MS Access:

Drop Index

index_name ON table_name

SQL Server:

Drop Index

table_name. index_name

DB2/Oracle:

Drop Index

index_name

MySQL:

Alter Table

table_name

Drop Index

index_name

SQL DROP INDEX Keyword

Concept visual

SQL DROP INDEX Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

DROP INDEX Keyword

Drop Index

The DROP INDEX

command is used to delete an index in a table.

MS Access:

Drop Index

index_name ON table_name

SQL Server:

Drop Index

table_name. index_name

DB2/Oracle:

Drop Index

index_name

MySQL:

Alter Table

table_name

Drop Index

index_name

SQL DROP INDEX Keyword

SQL DROP INDEX Keyword

DROP INDEX Keyword

Previous

Next

Drop Index

The DROP INDEX

MS Access:

Drop Index

SQL Server:

Drop Index

DB2/Oracle:

Drop Index

MySQL:

Alter Table

Drop Index

Previous

Next

SQL DROP INDEX Keyword

SQL DROP INDEX Keyword

DROP INDEX Keyword

Previous

Next

Drop Index

The DROP INDEX

MS Access:

Drop Index

SQL Server:

Drop Index

DB2/Oracle:

Drop Index

MySQL:

Alter Table

Drop Index

Previous

Next