-- generator on mysql
select 
    concat('truncate table dbo.', 
        t.TABLE_NAME,
        ';')
from INFORMATION_SCHEMA.TABLES t
where t.TABLE_SCHEMA = database();

-- generated on mssql
/*
truncate table dbo.cf_AclResource;               
truncate table dbo.cf_AclResource2Role;          
truncate table dbo.cf_AclResourcePrivilege;      
truncate table dbo.cf_AclRole;                   
truncate table dbo.cf_AclRule;                   
truncate table dbo.cf_Client;                    
truncate table dbo.cf_Client2User;               
truncate table dbo.cf_DPermission;               
truncate table dbo.cf_DPrivilege;                
truncate table dbo.cf_DResource;                 
truncate table dbo.cf_DState;                    
truncate table dbo.cf_DStatus;                   
truncate table dbo.cf_Department;                
truncate table dbo.cf_DepartmentAndProcessSorter;
truncate table dbo.cf_Form;                      
truncate table dbo.cf_FormElement;               
truncate table dbo.cf_FormElementProperty;       
truncate table dbo.cf_FormElementPropertyValue;  
truncate table dbo.cf_FormSubmission;            
truncate table dbo.cf_FormSubmissionValue;       
truncate table dbo.cf_Media;                     
truncate table dbo.cf_Part;                      
truncate table dbo.cf_Part2PartData;             
truncate table dbo.cf_Part2Process;              
truncate table dbo.cf_Part2ProcessData;          
truncate table dbo.cf_Part2User;                 
truncate table dbo.cf_PartVersion;               
truncate table dbo.cf_Process;                   
truncate table dbo.cf_Process2User;              
truncate table dbo.cf_User;                      
truncate table dbo.cf_User2Department;           
truncate table dbo.cf_User2Permission;           
truncate table dbo.cf_zz_Admin;                  
truncate table dbo.cf_zz_DFileType;              
truncate table dbo.cf_zz_DLanguage;              
truncate table dbo.cf_zz_DNotFoundMode;          
truncate table dbo.cf_zz_DPageHandler;           
truncate table dbo.cf_zz_DPageItemGroup;         
truncate table dbo.cf_zz_DPageItemType;          
truncate table dbo.cf_zz_DPageOption;            
truncate table dbo.cf_zz_DraftHtmlBlock;         
truncate table dbo.cf_zz_DraftHtmlBlockContent;  
truncate table dbo.cf_zz_DraftPage;              
truncate table dbo.cf_zz_DraftPageContent;       
truncate table dbo.cf_zz_DraftPageItem;          
truncate table dbo.cf_zz_DraftPageItemConfig;    
truncate table dbo.cf_zz_DraftPageOption;        
truncate table dbo.cf_zz_File;                   
truncate table dbo.cf_zz_HtmlBlock;              
truncate table dbo.cf_zz_HtmlBlockContent;       
truncate table dbo.cf_zz_Log;                    
truncate table dbo.cf_zz_NotFound;               
truncate table dbo.cf_zz_Page;                   
truncate table dbo.cf_zz_PageContent;            
truncate table dbo.cf_zz_PageIndex;              
truncate table dbo.cf_zz_PageItem;               
truncate table dbo.cf_zz_PageItemConfig;         
truncate table dbo.cf_zz_PageOption;             
truncate table dbo.cf_zz_Redirection;            
truncate table dbo.cf_zz_Settings;               
truncate table dbo.cf_zz_SettingsCategory;       
truncate table dbo.cf_zz_SettingsOptions;        
*/