Try this SQL, it start with "-- Note". I believe it is what you are looking for. 

-- Note: The sequence of data columns selected must be of the same data...

The proc below lists all tables in a database that contain identity columns (auto-incremet values). It skips System tables but you can change that setting. Modify the database setting, etc. for your site