UserId columns in simplified SEDE schema

0

Please login or register to vote for this query.

(click on this box to dismiss)

CiviCRM

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT [table]  = t.name, 
       [column] = c.name
  FROM sys.columns AS c 
  INNER JOIN sys.tables AS t
    ON c.[object_id] = t.[object_id]
  WHERE c.name LIKE '%UserId';

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results