tableName in metadata not showing

37 views
Skip to first unread message

Erik Reppen

unread,
Oct 18, 2017, 11:02:38 AM10/18/17
to tedious
Is that property just a stub or do I need to do something to enable setting the table name? The SQL in question being executed is just very vanilla select/from/where statements. No aliases or joins in 2/3. Here's the simplest one:

SELECT
Content,
        ContentID
        FROM ContentItems
WHERE LastModifiedByUserID != -1
AND (ContentTypeID = 1
OR ContentTypeID = 2
OR ContentTypeID = 7)
AND ContentItems.Content LIKE '%href%'

Getting the table-name would be convenient for the replace portion of writing a find/replace tool for links in our CMS DB.
Reply all
Reply to author
Forward
0 new messages