Archive for tag: system catalog views

TIE Fighters and sys.types: “There’s Too Many of Them!”

19 July, 2010 (08:39) | SQL, T-SQL | By: Mark V

As the Y-Wing pilot in Star Wars: Episode VI – Return of the Jedi proclaimed, sometimes there’s too many of them. He was referring to TIE Fighters during the assault on the second Death Star. I echoed the sentiment while querying the system catalog for a client’s database. I was building the foundation for a […]

Finding Foreign Keys

11 March, 2010 (12:59) | SQL, T-SQL | By: Mark V

No, this is not a new initiative by United States Immigration and Customs Enforcement. I am talking databases. I recently found myself in a situation where I wanted to find all the tables that referenced a particular table via foreign key relationships. I had heard that relying on the built-in dependency tracking (right-clicking the object […]