What are the columns of the BBC table?
Jump to navigation
Jump to 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'