Database Discussion - how to create/drop index as defrag?

Print Page | Close Window

how to create/drop index as defrag?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24158
Printed Date: 28 March 2026 at 5:31pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: how to create/drop index as defrag?

Posted By: chong67
Subject: how to create/drop index as defrag?
Date Posted: 13 August 2007 at 1:17am

Does anyone know how to drop index and create the index back for the Web Wiz forum db?

I am using it on my SQL 2005 and I only know how to backup and restore db.

Can anyone teach or show me or any good URL for it?

Thanks a million!