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

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

