We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

DB Table structure

Krish
8 - Asteroid

could you please help me in getting table structure details for oracle db table?

 

I used input data tool and connected oracle db.But I could not use desc table or sp_help table kind of statements.

 

Any idea?

 

Regards,

Krishna 

1 REPLY 1
Krish
8 - Asteroid

With this query in the tool,

 

SELECT  table_name, column_name, data_type, data_length FROM all_tab_columns where table_name = 'Table Name'

 

I am able to extract structure data 

Labels