(SQL SERVER) REQUÊTE POUR RECHERCHER UN {GUID} DANS TOUS LES CHAMPS DE TOUTES LES TABLES D'UNE BASE DE DONNÉES

-- Crée par : L.Attig
-- Date		: 10/2009
-- http://www.etoile-du-sahel.com/
DECLARE @strValeur uniqueidentifier
SET @strValeur = '{0F447BEF-C5BF-DE11-871F-00155D003604}'

IF OBJECT_ID('tempdb..#resultat') IS NOT NULL DROP TABLE #resultat
CREATE TABLE #resultat (TableSchema SYSNAME, TableName SYSNAME);
DECLARE @sql NVARCHAR(MAX);
WITH cte_all_tables(SQL) AS (
    SELECT
          N' INSERT #resultat (TableSchema, TableName)'
        + N' SELECT ''' + t.TABLE_SCHEMA + ''', ''' + t.TABLE_NAME + N'''' 
        + N' FROM ' + QUOTENAME(t.TABLE_SCHEMA) + '.' +QUOTENAME(t.TABLE_NAME)
        + N' WHERE ' +
        (
                SELECT QUOTENAME(c.COLUMN_NAME) + N' = @strValeur OR '
                FROM INFORMATION_SCHEMA.Columns c
                WHERE c.TABLE_NAME = t.TABLE_NAME
                        AND c.TABLE_SCHEMA = t.TABLE_SCHEMA
                        AND c.DATA_TYPE = 'uniqueidentifier'
                FOR XML PATH('')
        ) + N'0=1'
   FROM INFORMATION_SCHEMA.Columns c
        INNER JOIN INFORMATION_SCHEMA.Tables t
        ON c.TABLE_NAME = t.TABLE_NAME
        AND t.TABLE_SCHEMA = c.TABLE_SCHEMA
        AND t.TABLE_TYPE = 'BASE TABLE'
    WHERE DATA_TYPE = 'uniqueidentifier')
SELECT @sql = (SELECT [SQL]+nchar(10) FROM cte_all_tables FOR XML PATH(''));

PRINT @SQL;
exec sp_executesql @sql, N'@strValeur uniqueidentifier', @strValeur;

-- Retourne la liste des tables
SELECT distinct(Tablename) FROM #resultat