In the above demo, I included all the tables in my Azure SQL Database (AdventureWorksLT) and asked Copilot to build a query to show me sales by sales rep and product color.

Using MS SQL Server, is there a way to query all of the tables in a database for a specific column name?Thanks,Pete ...

Use partitioning to avoid large data moves SQL Server Enterprise offers “partitioning,” which allows you to split database tables into multiple partitions.