If we create any list workflows or any other type .xsn file or .aspx files will create. Where these files are stored in content DB or in physical folder? If it is in physical folder then what is the path of the storage location.
If you create workflows using SharePoint designer everything will be stored in the content database.
If yu create workflows using Visual Studio the files will be stored where you specify hat they should be stored inside the SharePointRoot Folder.
I agree above Answer and SharePoint designer workflows we can check in Designer having wfpub in that folder having all .xsn,xoml and rules files. each design workflow having a separate folder.
path is : Open Designer --> All files (left hand side) --> wfpub --> click and check
It depends on whether you have a subsite or not. But in general it's located in:
Sitename >> All Files >> Workflows >> YourWorkFlowName
Each WF contains the following files:
workflowname.xsn - which is your form for running the WF manually (if I remember correctly)