http://sqlzoo.net/w/index.php?title=What_is_the_syntax_to_view_structure_of_table%3F&feed=atom&action=history
What is the syntax to view structure of table? - Revision history
2013-06-20T00:59:14Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=What_is_the_syntax_to_view_structure_of_table%3F&diff=1708&oldid=prev
Connor at 09:57, 18 July 2012
2012-07-18T09:57:36Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 09:57, 18 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 15:</td>
<td colspan="2" class="diff-lineno">Line 15:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>sp_columns @table_name=bbc</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>sp_columns @table_name=bbc</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='def e-mysql'>show columns from <del class="diffchange diffchange-inline">gisq.</del>bbc</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='def e-mysql'>show columns from bbc</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SQL</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SQL</div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=What_is_the_syntax_to_view_structure_of_table%3F&diff=1487&oldid=prev
Connor at 12:39, 17 July 2012
2012-07-17T12:39:33Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 12:39, 17 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 8:</td>
<td colspan="2" class="diff-lineno">Line 8:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-db2'>SELECT * FROM syscat.columns</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-db2'>SELECT * FROM syscat.columns</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>WHERE tabname= '<del class="diffchange diffchange-inline">CIA</del>'</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>WHERE tabname= '<ins class="diffchange diffchange-inline">BBC</ins>'</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'>SELECT * FROM all_tab_columns</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'>SELECT * FROM all_tab_columns</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>  WHERE table_name='<del class="diffchange diffchange-inline">CIA</del>'</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>  WHERE table_name='<ins class="diffchange diffchange-inline">BBC</ins>'</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>sp_columns @table_name=<del class="diffchange diffchange-inline">cia</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>sp_columns @table_name=<ins class="diffchange diffchange-inline">bbc</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='def e-mysql'>show columns from gisq.<del class="diffchange diffchange-inline">cia</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='def e-mysql'>show columns from gisq.<ins class="diffchange diffchange-inline">bbc</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SQL</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SQL</div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=What_is_the_syntax_to_view_structure_of_table%3F&diff=1486&oldid=prev
Connor: Created page with "What is the syntax to view structure of table? <div class='ht'> <div class=params>schema:gisq</div> <div> What is the syntax to view structure of table? </div> <source lang=sq..."
2012-07-17T12:38:14Z
<p>Created page with "What is the syntax to view structure of table? <div class='ht'> <div class=params>schema:gisq</div> <div> What is the syntax to view structure of table? </div> <source lang=sq..."</p>
<p><b>New page</b></p><div>What is the syntax to view structure of table?<br />
<div class='ht'><br />
<div class=params>schema:gisq</div><br />
<div><br />
What is the syntax to view structure of table?<br />
</div><br />
<source lang=sql class='tidy'><br />
</source><br />
<source lang='sql' class='def e-db2'>SELECT * FROM syscat.columns<br />
WHERE tabname= 'CIA'<br />
</source><br />
<source lang='sql' class='def e-oracle'>SELECT * FROM all_tab_columns<br />
WHERE table_name='CIA'<br />
</source><br />
<source lang='sql' class='def e-sqlserver'>sp_columns @table_name=cia<br />
</source><br />
<source lang='sql' class='def e-mysql'>show columns from gisq.cia<br />
</source><br />
<source lang='sql' class='def'>SQL<br />
</source><br />
<div class="ecomm e-oracle" style="display: none">From within sqlplus we can use the DESCRIBE command. Outside sqlplus we can access the view all_tab_columns </div><br />
</div><br />
{{Meta Data ref}}</div>
Connor