Category: sql

How to specify an order for the columns in a matrix?

Post author By user user
Post date July 7, 2021
Categories In matrix, reporting-services, sql, visual-studio
9 Comments on How to specify an order for the columns in a matrix?

I’m working on a SQL Reporting Services report (in VS.Net 2005) which displays a count of different data in a matrix. The columns have a count on the amount of customers in a certain set. So I have several columns like these: “1 employer”, “2-9 employers”, “10-19 employers” and so on. The problem I have […]

How can I list all foreign keys referencing a given table in SQL Server?

Post author By user user
Post date July 7, 2021
Categories In sql, sql-server, tsql
28 Comments on How can I list all foreign keys referencing a given table in SQL Server?

I need to remove a highly referenced table in a SQL Server database. How can I get a list of all the foreign key constraints I will need to remove in order to drop the table? (SQL answers preferable over clicking about in the GUI of the management studio.)