Hibernate does not use sp_tables. Hibernate simply uses the capabilities provided by JDBC; your driver is simply forwarding that as a call to sp_tables.

Use of database vendor specific schema metadata schema or props is beyond the scope of Hibernate. We do however offer pluggable extension points allowing you to tell Hibernate a different way to obtain the necessary information an alternative way.