What is the syntax to view structure of table?

From SQLZOO
Revision as of 12:38, 17 July 2012 by Connor (Talk | contribs) (Created page with "What is the syntax to view structure of table? <div class='ht'> <div class=params>schema:gisq</div> <div> What is the syntax to view structure of table? </div> <source lang=sq...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

What is the syntax to view structure of table?

schema:gisq

What is the syntax to view structure of table?

 
SELECT * FROM syscat.COLUMNS
WHERE tabname= 'CIA'
SELECT * FROM all_tab_columns
 WHERE TABLE_NAME='CIA'
sp_columns @TABLE_NAME=cia
SHOW COLUMNS FROM gisq.cia
SQL