You can increase log level to DEBUG for org.jboss.ejb,plugins.cmp and watch executed SQL or copy it from server.log
Yes, one can have all SQL stuff logged and then find it in the log files. However it can not be done if tables are already created and one does not want to drop them.
We have situation where we have set JBoss to create tables on deploy. It is very convenient while we are developing and testing. But now we are going to move to production environment and would like to create tables manually so we can do some optimizations. I thought it would be nice if I could simply export database schema from JBoss and just make small corrections instead of typing hundreds of lines of SQL code.
I just think such functionality may be very useful. In future JBoss versions may be.