Export all tables from SQL Server into separate files

sql-server

Solution

Go to Object Explorer, pick `Generate Scripts`:

Then select what objects to script out, and on the second page of the wizard, select `Single File Per Object`:

Run the wizard and you have your one file per object as you need it.

Problem

I want to extract only table structure from a SQL Server database. But if I extract normally using export wizard only single file is created but I want to create separate files for separate tables. Could anybody tell me how to do this in SQL Server ?

Original source