What are the columns of the BBC table?

From SQLZOO
Revision as of 09:57, 13 July 2012 by Connor (Talk | contribs) (Created page with "What are the columns of the bbc table <div class='ht'> <div class=params>schema:gisq</div> <source lang=sql class='tidy'> </source> <source lang=sql class='setup'></source> <s...")

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

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'