Joffery improved my script to find tables with foreign key constraint in a database, adding the ON UPDATE and ON DELETE rules and a little ordering.
SQL SERVER – Find Table in Every Database of SQL Server – Part 2 Extension
Two more ways from Simon Worth to find table in every database of SQL Server, both built on sp_msforeachdb, one saving results to a temp table.
NOT and NULL: Unknown Does Not Become True
NOT and NULL do not create a complete two-way classification. State whether missing values belong in a filter or a separate reporting category.
SQL SERVER – Find Table in Every Database of SQL Server – Part 2
Part 2 of how to find a table in every database of SQL Server: this stored procedure loops through sys.databases and reads the Information_Schema view.
SQL SERVER – Find Table in Every Database of SQL Server
sys.tables only searches one database. My quick stored procedure finds a table in every database on the server and returns database, schema and table name.
CHARINDEX Start Position: Find the Second Delimiter
CHARINDEX start position finds the next delimiter. Guard a missing first match, preserve NULL, and extract empty fields without negative lengths.
SQL SERVER – Converting Subqueries to Joins
Developers often write subqueries where Joins would do, or the other way around. A short note on converting between the two, with links to my earlier examples.