What is the syntax to view structure of table?

From SQLZoo
Jump to navigation Jump to 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
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects