Script to recreate existing tables including indexs


  • Hi SQL Gurus,

    I need to get the generate table scripts for Selected tables(around 200) from many tables in the data base. Is there a query avaialble to do it? It chould include triggers, constraints and indexs in the table.

    Any help is appreciated.

    My Blog    |      Ask Me     |      SSIS Basics     

    Wednesday, March 06, 2013 1:12 PM


  • Hit the advanced button and then set your options for the script generation:

    Chuck Pedretti | Magenic – North Region |

    • Marked as answer by Sudeep Raj Wednesday, March 06, 2013 1:36 PM
    Wednesday, March 06, 2013 1:24 PM

All replies