I find it interesting if I right click on a table and select
SCRIPT TABLE AS - CREATE TO - New Query Editor Window ,
The output of it does not show all indexes that were created on table.
Why is that?
So if used the output to recreate the table again, not all the indexes that were there will get recreated.
I am user SQL Server Management 2008.