#AcumaticaTnT Searching Acumatica Database Column Names

Here's some SQL code that you can use to search across all of the column names in the Acumatica database. This code will return all Columns that have InventoryID in the name, but only from Tables that start with IN:

SELECT t.name AS 'TableName',c.name AS 'ColumnName'
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%InventoryID%' AND t.name LIKE 'IN%'
ORDER BY TableName,ColumnName

The % symbol acts like a wildcard so %InventoryID% means anything with InventoryID anywhere in the column name. IN% means only tables that start with IN. If you only wanted columns that equal InventoryID, just remove the % symbols. If you only want columns or tables that end with the letter "y", you could put %y.