Dissecting a database again the joys of trying to work out what talks to what.
Some time ago I blogged a post about finding table information from sql server well the query below has proved useful today in working out what tables are used as part of the application i'm analysing.
SELECT TABLE_NAME,TABLE_ROWS,UPDATE_TIME AS LASTUPDATED FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = 'MYDATABASENAME'
ORDER BY UPDATE_TIME desc
WHERE table_schema = 'MYDATABASENAME'
ORDER BY UPDATE_TIME desc
Copyright © 2011 Pixl8 Interactive, 3 Tun Yard, Peardon Street, London, SW8 3HT