The following SQL script generation options are available in the Schema Wizard:
Ability to generate DROP object SQL statements in a script. For example, it is required when your target database already contains the objects with the same name as new ones, and you must drop them first to be able to create new objects.
Ability to include indexes into generated script. Sometimes you might want to replicate schema without indexes. For example, for some test purposes you might want to load some tables with test garbage data, which does not satisfy unique index constraints.
Ability to include referential integrity constraints. In some cases you might want to create a test database without referential integrity defined.
Ability to include physical layout definitions. You can use this option if you want to preserve or skip fragmentation definitions or db spaces allocations. If you choose to preserve physical layout, you will have an option to remap source spaces to a target server spaces, if a target has a different set of spaces.