topic Re: What are ways to get Table structure? in Talend Studio

What are ways to get Table structure?

ankit7359 — Thu, 16 May 2019 08:38:29 GMT

Hi Community,

It is obvious that we can get to see the Table structure when the Db connection is put in repository and then when the table is imported then we can see the list of columns which are present in the table. But what are the other ways or methods to view the Table structure/fields within in it.

Thanks,

Ankit

Re: What are ways to get Table structure?

fdenis — Thu, 16 May 2019 09:33:18 GMT

there is no other way with talend. it's an ETL not a "db Administration Tool".

Talend import information from a lot of bd. you can also manually create them. but it's not a db tool.
Regards,

Re: What are ways to get Table structure?

Anonymous — Thu, 16 May 2019 09:34:13 GMT

Hello,

You could use tDBColumnList to iterate on all columns of a given database table and lists column names.

Best regards

Sabrina