Export all tables from SQL Server into separate files

Question

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 ?

Answer 1

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.