What is the syntax to view structure of table?

From SQLZOO
Revision as of 12:39, 17 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 gisq.bbc
SQL
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense