SQL query to get table information

Hi,

Want to check table info (table columns and column types) using SQL query. Tried describe tablename - didn’t work.

Any suggestion ?

Thanks!
Dipanwita

Hi @dipanwita2019,

Try to use the sql command

show create table *table name*;

You should get a create table statement with datatypes, encoding and constraints like not nullable fields

1 Like