Omnisci SQL and pymapd

Hi,

I am trying to check the data types of the columns in the omniscidb table using SQL. I am using pymapd to run queries.

would be nice if anyone can give me the command to check the dtypes.

Thanks
Dipanwita.

Hi @dipanwita2019,

You can run the SQL command show create table my_table; to get the DDL for my_table. This should give you the column names and their data types, as well as any additional table options.

1 Like