DECLARE @NAME_TO_SEARCH_FOR nvarchar(50)
SET @NAME_TO_SEARCH_FOR = '%photo%'
SELECT sysobjects.name AS Table_Name, syscolumns.name AS Column_Name
FROM syscolumns INNER JOIN sysobjects ON syscolumns.id = sysobjects.id
WHERE syscolumns.name LIKE @NAME_TO_SEARCH_FOR AND sysobjects.Type Like 'U%'
6808cf63-ee08-4321-983a-133df4b75ebc|3|3.7
General
Database