I must be going mad. I’ve worked on thousands of database schemas over the years, including a lot of “conformed data warehouses” where there are a lot of different business areas in one user database, separated either by schema (newer style) or by some funky naming convention (older style). I’ve always found that SSMS can … Continue reading SMS Tip of the Day – Filtering Tables
Tag: SQL Server
Here is some handy TSQL to determine all the FK relationships in a database. The basic ideas is we can use this meta data to automatically determine if a form should have a Combo Box rendered instead of a textbox. -- List all Foreign key Relationships in User Tables SELECT so.name as ForeignTableName, sc.name as … Continue reading TSQL to determine all FK’s in a database