Using this query you can easy to track that, Which running SQL Query is taking extra time or load, check reads and writes. Output will be. Query
Using this query you can easy to get all primary keys of from all tables of current database. Output will be like this.
Using this query we can easy to check all relationships in current Database. We have 2 different queries you can find below. Example picture this there. 1st Query 2nd Query
Some time table identity value comes wrong sake of we delete manual entries, we added wrong data in edit mode or it takes next value of identity or some time automatically comes. So in this case many developer are delete data or re-design to table structure (schema). No need to do this you just clear … Read more