What are the columns of the BBC table?

From SQLZoo

What are the columns of the bbc table

schema:gisq
SELECT sql FROM sqlite_master
WHERE name='bbc'

SELECT * FROM syscat.columns
WHERE tabname='BBC'

SELECT attnum,attname from pg_class, pg_attribute
WHERE relname='bbc'
  AND pg_class.oid=attrelid
  AND attnum > 0

SELECT * FROM all_tab_columns
 WHERE table_name='BBC'

SELECT syscolumns.* 
FROM syscolumns JOIN sysobjects
       ON syscolumns.id=sysobjects.id
WHERE sysobjects.name='bbc'

show columns from bbc

SELECT syscolumns.* 
FROM syscolumns JOIN sysobjects
       ON syscolumns.id=sysobjects.id
WHERE sysobjects.name='bbc'
Meta Data
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects
  • Your server today is: digitalocean-sqlzoo
    • Retrieved from ‘http://sqlzoo.net/w/index.php?title=What_are_the_columns_of_the_BBC_table%3F&oldid=39035’