What is the syntax to view structure of table?

From SQLZOO
Revision as of 09:57, 18 July 2012 by Connor (talk | contribs)
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= 'BBC'
SELECT * FROM all_tab_columns
 WHERE table_name='BBC'
sp_columns @table_name=bbc
show columns from bbc
SQL