Eine Einführung in
SQL
What are the columns of the cia table?
SQLite
SELECT sql FROM sqlite_master WHERE name='cia'
Specific to SQLite
You can examine the SQL create statement.
DB2
SELECT * FROM syscat.columns WHERE tabname='CIA'
Specific to DB2
none
MS Access
Specific to MS Access
none
PostgreSQL
SELECT attnum,attname from pg_class, pg_attribute WHERE relname='cia' AND pg_class.oid=attrelid AND attnum > 0
Specific to PostgreSQL
none
Oracle
SELECT * FROM all_tab_columns WHERE table_name='CIA'
Specific to Oracle
When working with the sqlplus interface you can simply ask DESCRIBE cia;
Notice that the table name is in upper case.
See also USER_TAB_COLUMNS
Manual page.
MS SQL Server
SELECT syscolumns.* FROM syscolumns JOIN sysobjects ON syscolumns.id=sysobjects.id WHERE sysobjects.name='cia'
Specific to MS SQL Server
Also:
sp_columns @table_name=cia
MySQL
show columns from cia
Specific to MySQL
none
Sybase
SELECT syscolumns.* FROM syscolumns JOIN sysobjects ON syscolumns.id=sysobjects.id WHERE sysobjects.name='cia'
Specific to Sybase
Also:
sp_columns @table_name=cia
Mimer SQL
Specific to Mimer SQL
none