Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Need an sql command to view the table structure in Base.

I would like to view the structure of my tables (without data) and print them out eventually or copy them to where they can be printed in order to see on paper the two or three tables compared to one another. Is this possible. I have tried using:

1

SELECT * FROM information_schema.columns WHERE table_name = 'Table_Name' ORDER BY ordinal_position

and #2 DESC or DESCRIBE : Used to describe the table structure present in the tablespace.

Both of these seem to have failed. I don't find that this seems to be possible in Base