Run DBCC CHECKDB on the database to make sure that it's not corrupted.

>I have problem that, my table in SQL Server is accidently dropped, however, its index and constraint still exist. It caused I am not able to recreate the table. How could I clean it up?
>