I can pick a database and select Generate DDL script. This dialog will allow me to pick tables, views, store procedures, etc. and generate script for them; however, can I automatically sort the generated files by object type or by individual object names?
For example, if I selected Table1, Table2... TableN, does the Generate DDL Script feature have an option where it will generate automatically File1, File2... FileN, each corresponding to Table1, Table2... TableN?
Or if I want scripts for Table1 to TableN to go into one file and the scripts for Proc1 to ProcN to go into another file, can the Generate DDL Script feature automatically generate FileN for all the tale scripts and FileP for all the procedure scripts?
Enhancement request has been submitted to Development for consideration in a future release of Toad for SQL Server.