Drop index..? 1

[kenjoswe]

Hi all,

How can I drop an index if it exists and create an index if it doesn't exists?

/Kent J.

 

[tlbroadbent]

You can do the following.

USE pubs
IF EXISTS (SELECT name FROM sysindexes
WHERE name = 'au_id_ind')
BEGIN
DROP INDEX authors.au_id_ind
END
GO

CREATE INDEX au_id_ind
ON authors (au_id)

See SQL BOL "CREATE INDEX" and "DROP INDEX" topics for more options and details. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[kenjoswe]

OK! Thanks!

/Kent J.