locked
Script table and data? RRS feed

  • Question

  • Is there a way to script to script a table and its data? In SQL 2008 r2?

    M~

    Wednesday, August 15, 2012 5:51 PM

Answers

  • You can use the Generate Script Wizard in SSMS to script schema and data.  Right-click on the database -> Tasks -> Generate Scripts.  The default option is to only script schema, but you can change the option in Set Scripting Options -> Advanced -> Types of Data to Script.

    Thanks,
    Sam Lester (MSFT)


    My Blog

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    • Marked as answer by WIJ Wednesday, August 15, 2012 6:08 PM
    Wednesday, August 15, 2012 6:07 PM