Locating a Field in the Database

[michael_franz]

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.

[JohnJPS · Accepted 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.)

[michael_franz]

YES!!!!!!!! THANKS!!!!!!!!!!!!!!!!!!!!!!