 <p>There's no built-in way to get INSERTs for all the rows in a result set using SQL Assistant. </p> <p>There's an ugly workaround using the <code>CSV</code>-UDF like:</p> <pre><code>WITH cte AS ( -- put your select here SELECT * FROM dbc.tablesV ) SELECT * FROM TABLE (CSV(NEW VARIANT_TYPE( -- you need to list each column of your table cte.DataBaseName ,cte.TABLENAME ,cte.Version ,cte.TableKind ,cte.ProtectionType ,cte.JournalFlag ,cte.CreatorName ,cte.RequestText ,cte.CommentString ,cte.ParentCount ,cte.ChildCount ,cte.NamedTblCheckCount ,cte.UnnamedTblCheckExist ,cte.PrimaryKeyIndexId ,cte.RepStatus ,cte.CreateTimeStamp ,cte.LastAlterName ,cte.LastAlterTimeStamp ,cte.RequestTxtOverflow ,cte.AccessCount ,cte.LastAccessTimeStamp ,cte.UtilVersion ,cte.QueueFlag ,cte.CommitOpt ,cte.TransLog ,cte.CheckOpt ,cte.TemporalProperty ,cte.ResolvedCurrent_Date ,cte.ResolvedCurrent_Timestamp ,cte.SystemDefinedJI ,cte.VTQualifier ,cte.TTQualifier ,cte.PIColumnCount ,cte.PartitioningLevels ,cte.LoadProperty ,cte.CurrentLoadId ,cte.LoadIdLayout ,cte.DelayedJI ), ',', '"') RETURNS (op VARCHAR(32000) CHARACTER SET UNICODE) ) AS dt; </code></pre> <p>Otherwise you must use a different tool...</p>