It is also useful if you are running SQL statements from an SQL application in another SQL-based database. The second form uses a LIKE clause to create a table that has the same column names and ...

Learn how to drop an index in SQL Server using T-SQL or SSMS, ... Table Designer or (3) Transact-SQL. (1) Expand the database that contains the table on which you want to delete an index.