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

Since version 5.2.1 you can view this information in SQL Editor by running:

SHOW CREATE TABLE <table or view name>;

Similarly, you could get this information from pymapd:

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

list(DDL)

0 comments

Article is closed for comments.