This script will go through all the tables in the model write their CREATE script to a seperate file per table. A script file to execute all of the seperate table scripts is also created. 1) bring up the Script Explorer 2) right click on "User Defined" and select "New Script" 3) copy/paste the script below into the edit control 4) hit the run button (the first icon in the toolbar above the edit control) Note: you can undo/redo the effects of this script as with any Model changes /********** start of script *************/ Sub Evaluate_OnLoad() Set Context = CreateObject("SCF.ScriptContext") Set Document = Context.ScriptDocument Set Script = Context.Object Set Options = Context.Options Set Model = Script.Model.AsObject strDirectory = "c:\test" strFile = "\driver.sql" ' Create the File System Object Set objFSO = CreateObject("Scripting.FileSystemObject") ' Create the Folder specified by strDirectory on line 10 Set folder = objFSO.CreateFolder(strDirectory) Set ControlFile = objFSO.CreateTextFile(strDirectory & strFile) For Each Table In Model.Children("Table") Document.Write(Table.Name & vbLf) strFile = "\" & Table.Name & ".sql" Set TableFile = objFSO.CreateTextFile(strDirectory & strFile) TableFile.WriteLine(Table.Evaluate("Create Script")) TableFile.Close ControlFile.WriteLine("exec " & strDirectory & strFile) Next ControlFile.Close End Sub