I am using In-DB, but I can not locate a field. I've tried to just look through tables to find field to join to, but there are sooooo many tables. I do not have a dictionary of the DB, but is there a way to search for a "field name" using alterxy or sql directly.
Solved! Go to Solution.
For SQL Server...
select st.name TableName, sc.name ColumnName
from DataBaseName.sys.tables st
inner join DataBaseName.sys.columns sc on sc.object_id = st.object_id
You can use an ordinary input tool with this query to look at your columns in a browse tool (then use Alteryx to find what you're looking for.)
YES!!!!!!!! THANKS!!!!!!!!!!!!!!!!!!!!!!