Use read-only queries for comparing two schemas, finding missing columns, checking type details, and reviewing indexes and modules.
MySQL – List User Defined Tables – Two Methods
There are different methods to list out user defined tables in MySQL. We will see two methods in this post.
Let us create the following tables in the database named Test
Tracking Recent Object Changes With modify_date
Use modify_date to find recent SQL Server object changes, compare databases, and understand which audit questions need event capture.
Comparing Two Database Schemas With T-SQL
Comparing two database schemas with catalog queries exposes missing objects, changed columns, and index differences before deployment.
Finding What Depends on a Table
Finding What depends on a table starts with sys.dm_sql_referencing_entities, then checks cross-database code and dynamic SQL.
Measuring Space Used by Tables per Filegroup in T-SQL
Measure tables per filegroup from allocation metadata, include LOB and overflow pages, and separate partition placement from growth history.
SQL SERVER – Finding Different ColumnName From Almost Identitical Tables
A reader had archive and current tables in pairs, but the schemas drifted apart. Here is my way of finding different ColumnName values in almost identical tables.