Difference between revisions of "What is the syntax to view structure of table?"
From SQLZOO
| Line 15: | Line 15: | ||
<source lang='sql' class='def e-sqlserver'>sp_columns @table_name=bbc | <source lang='sql' class='def e-sqlserver'>sp_columns @table_name=bbc | ||
</source> | </source> | ||
| − | <source lang='sql' class='def e-mysql'>show columns from | + | <source lang='sql' class='def e-mysql'>show columns from bbc |
</source> | </source> | ||
<source lang='sql' class='def'>SQL | <source lang='sql' class='def'>SQL | ||
Latest revision as of 09:57, 18 July 2012
What is the syntax to view structure of table?
schema:gisq
What is the syntax to view structure of table?
SELECT * FROM syscat.COLUMNS WHERE tabname= 'BBC'
SELECT * FROM all_tab_columns WHERE TABLE_NAME='BBC'
sp_columns @TABLE_NAME=bbc
SHOW COLUMNS FROM bbc
SQLWhat is the syntax to view structure of table?
