Eine Einführung in
SQL
What is the syntax to view structure of table?
SQLite
What is the syntax to view structure of table?
See also
What are the columns of the ci table?
SQL
Specific to SQLite
none
DB2
What is the syntax to view structure of table?
See also
What are the columns of the ci table?
SELECT * FROM syscat.columns WHERE tabname= 'CIA'
Specific to DB2
none
MS Access
What is the syntax to view structure of table?
See also
What are the columns of the ci table?
SQL
Specific to MS Access
none
PostgreSQL
What is the syntax to view structure of table?
See also
What are the columns of the ci table?
SQL
Specific to PostgreSQL
none
Oracle
What is the syntax to view structure of table?
See also
What are the columns of the ci table?
SELECT * FROM all_tab_columns WHERE table_name='CIA'
Specific to Oracle
From within sqlplus we can use the DESCRIBE command. Outside sqlplus we can access the view all_tab_columns
MS SQL Server
What is the syntax to view structure of table?
See also
What are the columns of the ci table?
sp_columns @table_name=cia
Specific to MS SQL Server
See the section on
MySQL
What is the syntax to view structure of table?
See also
What are the columns of the ci table?
show columns from gisq.cia
Specific to MySQL
none
Sybase
What is the syntax to view structure of table?
See also
What are the columns of the ci table?
SQL
Specific to Sybase
none
Mimer SQL
What is the syntax to view structure of table?
See also
What are the columns of the ci table?
SQL
Specific to Mimer SQL
none