Sql Server Management Studio - Script Table AS feature

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.
Lawrence AverySystem DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

to include indexes right click the database

generate scripts.

select specific database objects

expand tables and select the table you want to script


click advanced then change to true the attributes you want to include in the script

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Lawrence AverySystem DeveloperAuthor Commented:
Not to be a know it all - After you right click the database, you first must select Tasks and then Generate scripts. Then the rest you mentioned is correct.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.