Post reply

Script tables but why not include their non-clustered indexes ?

  • April 14, 2010 at 11:15 pm

    #146420

    Hello, I am using SQL 2005, I right-clicked a database's tables and saved its table scripts as a text file or sent it to a new Query window.

    However, why the output didn't have its non-clustered indexes or unique constraints ?

    Consequently, I couldn't create some foregin keys.

    Please tell me how can I script a database's tables including their non-clustered indexes and/or unique constraints.

  • April 14, 2010 at 11:29 pm

    #1151879

    duplicate post.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply