Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Locating a Field in the Database

michael_franz
8 - Asteroid

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.

2 REPLIES 2
JohnJPS
15 - Aurora

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.)

Smiley LOL

michael_franz
8 - Asteroid

YES!!!!!!!! Smiley Happy THANKS!!!!!!!!!!!!!!!!!!!!!!

Labels