Schema Analysis | SQL Server Scripts

SQL Server Object Dependencies Report: Find All References
May 23, 2026 / May 25, 2026 · 8 min read · sql server dependencies object dependencies database administration refactoring sql scripts sys.sql_expression_dependencies sys.all_objects sys.all_columns impact analysis schema analysis sys.dm_sql_referenced_entities sys.dm_sql_referencing_entities sys.objects ·
Share on:
Before renaming a column, retiring a view, or dropping a stored procedure, every DBA needs the answer to one question: what else depends on this object? This T-SQL script reads sys.sql_expression_dependencies and reports every referencing-and-referenced pair in the current database, with optional filtering to a single …

Read More
SQL Server Find Columns by Data Type Across the Database
May 22, 2026 / May 25, 2026 · 7 min read · sql server columns data types schema analysis sql scripts sys.columns sys.types sys.tables sys.schemas database structure metadata sys.computed_columns sys.dm_db_index_physical_stats sys.foreign_keys sys.objects sys.views ·
Share on:
"Where is every datetime column?" — "Which tables still use text instead of varchar(max)?" — "Are any columns using a deprecated user-defined type?" These are recurring DBA questions during schema audits, deprecation sweeps, and pre-migration assessments. This T-SQL script joins sys.columns to sys.types, sys.tables, …

Read More