What are the columns of the BBC table? - Revision history

Connor: Created page with "What are the columns of the bbc table

schema:gisq

2012-07-13T09:57:07Z

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..."

New page
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>
<source lang='sql' class='def e-sqlite'>SELECT sql FROM sqlite_master
WHERE name='bbc'</source>
<source lang='sql' class='def e-db2'>SELECT * FROM syscat.columns
WHERE tabname='BBC'</source>
<source lang='sql' class='def e-ingres'> </source>
<source lang='sql' class='def e-access'> </source>
<source lang='sql' class='def e-postgres'>SELECT attnum,attname from pg_class, pg_attribute
WHERE relname='bbc'
AND pg_class.oid=attrelid
AND attnum > 0
</source>
<source lang='sql' class='def e-oracle'>SELECT * FROM all_tab_columns
WHERE table_name='BBC'
</source>
<source lang='sql' class='def e-sqlserver'>SELECT syscolumns.*
FROM syscolumns JOIN sysobjects
ON syscolumns.id=sysobjects.id
WHERE sysobjects.name='bbc'
</source>
<source lang='sql' class='def e-mysql'>show columns from bbc
</source>
<source lang='sql' class='def e-mimer'> </source>
<source lang='sql' class='def e-sybase'>SELECT syscolumns.*
FROM syscolumns JOIN sysobjects
ON syscolumns.id=sysobjects.id
WHERE sysobjects.name='bbc'
</source>
<div class="ecomm e-sqlite" style="display: none">You can examine the SQL create statement.</div>
<div class="ecomm e-oracle" style="display: none">When working with the sqlplus interface you can simply ask DESCRIBE bbc;
Notice that the table name is in upper case.
See also USER_TAB_COLUMNS
Manual page.</div>
<div class="ecomm e-sqlserver" style="display: none">Also: sp_columns @table_name=bbc</div>
<div class="ecomm e-sybase" style="display: none">Also: sp_columns @table_name=bbc</div>
</div>
{{Meta Data ref}}