Is there anyway to drop and re create all the index of a database ???

I wanna do that without usinf DBCC REINDEX
ThanksYou can write your own script which uses a couple of loops and the system tables and then drop and
create the indexes. But it gets more complicated as some indexes are created by constraints.
In fact, DBREINDEX uses the same code internally in SQL Server as CREATE INDEX, so why don't you
want to use DBREINDEX?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rubens Naves" <rubensnaves@.hotmail.comm> wrote in message
news:%231baqYJxDHA.556@.TK2MSFTNGP11.phx.gbl...
> I wanna do that without usinf DBCC REINDEX
> Thanks
>