How do I "Show" a Table or View definition?

You have multiple ways to get a table's DDL starting with \d <table or view name>of HEAVYSQL tool

Since version 5.2.1 you can view this information in SQL Editor by running:
SHOW CREATE TABLE <table or view name>;

By the version 6.0 you can querying the information_schema's table called table
select ddl_statement from information_schema.tables where table_name = <table or view name>

Similarly, you could get this information from heavyai python driver using the SHOW and system tables

DDL = con.execute('''
SHOW CREATE TABLE <table or view name>
''')

list(DDL)

Articles in this section

Comments

Articles in this section

Related articles