SQL
zoo.net
What are the columns of the cia table?
SQLite
DB2
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
SQL Server
SELECT syscolumns.* FROM syscolumns JOIN sysobjects ON syscolumns.id=sysobjects.id WHERE sysobjects.name='cia'
Specific to SQL Server
Also:
sp_columns @table_name=cia
Related links:
META DATA
What are my tables?
What are the columns of the cia table?
Get the first 10 rows of the gisq.cia table.
Get the 11th to the 20th rows of the cia table - by population.
What version of the software am I using?
What is the syntax to view structure of table?
How can you determine the primary key using SQL?
Return a sequential record count for all records returned