• Looks like an interview question.

    If "recreate table" means that all the data is reinserted in the table, the possible answers are:

    ALTER TABLE SomeTable REBUILD; -- Rebuilds a heap table

    ALTER INDEX SomeClusteredIndex ON SomeTable REBUILD; -- Rebuilds a clustered index

    -- Gianluca Sartori