MSSQL – ricerca in tutte le tabelle, campi che inizia/contiene
SELECT c.name AS ‘ColumnName’,t.name AS ‘TableName’FROM sys.columns cJOIN sys.tables t ON c.object_id = t.object_idWHERE c.name LIKE ‘QS%’ORDER BY TableName,ColumnName;
SELECT c.name AS ‘ColumnName’,t.name AS ‘TableName’FROM sys.columns cJOIN sys.tables t ON c.object_id = t.object_idWHERE c.name LIKE ‘QS%’ORDER BY TableName,ColumnName;