SQL Server 2019 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Food1(
	[Group] [nvarchar](100) NULL,
	[Quantity] [int] NOT NULL,
	[Color] [nvarchar](50) NULL,
) ON [PRIMARY];
CREATE TABLE Food2(
	[Code] [nvarchar](50) NOT NULL,
	[Quantity] [int] NOT NULL,
	[Color] [nvarchar](50) NULL,
) ON [PRIMARY];
CREATE TABLE Food3(
	[Code] [nvarchar](50) NOT NULL,
	[Group] [nvarchar](100) NULL,
	[Quantity] [int] NOT NULL,
) ON [PRIMARY];
SELECT A.name  AS 'ColumnName',B.name AS 'TableName',B.object_id AS 'ID'
FROM sys.columns A
INNER JOIN sys.tables B
ON A.object_id = B.object_id
WHERE A.name LIKE '%Code%'
ORDER BY TableName,ColumnName;


ColumnName
TableName
ID


Code
Food2
597577167

Code
Food3
613577224