Find the number of columns in a table

Question

It is possible to find the number of rows in a table   select count    from tablename   Is it possible to find the number of columns in a table

User · Answer

Or use the sys columns  --SQL 2005 SELECT    FROM    sys columns WHERE   OBJECT NAME object id     spt values  -- returns 6 rows   6 columns  --SQL 2000 SELECT    FROM    syscolumns WHERE   OBJECT NAME id     spt values  -- returns 6 rows   6 columns  SELECT    FROM    dbo spt values     -- 6 columns indeed

User · Answer

Since all answers are using COUNT    you can also use MAX   to get the number of columns in a specific table as  SELECT MAX ORDINAL POSITION  NumberOfColumnsInTable FROM INFORMATION SCHEMA COLUMNS WHERE TABLE CATALOG    YourDatabaseNameHere        AND        TABLE SCHEMA    YourSchemaNameHere        AND       TABLE NAME    YourTableNameHere     See The INFORMATION SCHEMA COLUMNS Table

User · Answer

Can get using following sql statement   select count    Noofcolumns from SYSCOLUMNS where id  select id from SYSOBJECTS where name  table name

User · Answer

A MySQL answer adapted slightly from the MSDN example for MySqlDataReader GetValues     assumes you ve already created a connection  opened it     and executed a query to a reader  while reader Read          Object   values   new Object reader FieldCount       int fieldCount   reader GetValues values        Console WriteLine   nreader GetValues retrieved  0  columns      fieldCount       for  int i   0  i  lt  fieldCount  i            Console WriteLine values i        Using MySqlDataReader FieldCount will allow you to retrieve the number of columns in the row you ve queried

User · Answer

Here is how you can get a number of table columns using Python 3  sqlite3 and pragma statement   con   sqlite3 connect   memory        con execute  CREATE TABLE tablename  d1 VARCHAR  d2 VARCHAR    cur   con cursor   cur execute  PRAGMA table info tablename    print len cur fetchall       Source

User · Answer

SELECT count    FROM information schema  COLUMNS  C WHERE table name    your table name  AND TABLE SCHEMA    your db name

User · Answer

Query to count the number of columns in a table   select count    from user tab columns where table name    tablename     Replace tablename with the name of the table whose total number of columns you want returned

User · Answer

SELECT COUNT COLUMN NAME   FROM INFORMATION SCHEMA COLUMNS  WHERE      TABLE CATALOG    Database name       AND TABLE SCHEMA    dbo       AND TABLE NAME    table name

User · Answer

Its been little late but please take it from me     In the editor New Query  by select the database object it can be a table too  if we use the Shortcut Key Alt F1 we will get all the information of the object and I think will solve your problem as well

User · Answer

SELECT count    FROM information schema columns WHERE table name    Your table name     Note  Your table name should be replaced by your actual table name

User · Answer

SELECT COUNT     FROM INFORMATION SCHEMA COLUMNS  WHERE     TABLE NAME    table name

User · Answer

It s working  mysql    SELECT TABLE NAME   count COLUMN NAME  FROM information schema columns GROUP BY TABLE NAME

User · Answer

SELECT COUNT      FROM INFORMATION SCHEMA COLUMNS  WHERE table catalog    database name  -- the database    AND table name    table name

User · Answer

It is possible to find the number of columns in a table just by using 3 simple lines of PHP code    sql  SELECT   FROM table    query mysqli query  connect dude  sql        num mysqli num fields  query      num would return the number of columns on a given table in this case   Hopefully it would help others

User · Answer

SELECT COUNT COLUMN NAME  FROM INFORMATION SCHEMA COLUMNS WHERE  TABLE CATALOG    database name  AND TABLE SCHEMA    dbo  AND TABLE NAME    table name

User · Answer

Well I tried Nathan Koop s answer and it didn t work for me  I changed it to the following and it did work   SELECT COUNT    FROM INFORMATION SCHEMA COLUMNS WHERE table name    table name    It also didn t work if I put USE  database name  nor WHERE table catalog    database name  AND table name     table name   I actually will be happy to know why

User · Answer

db2  describe table  SCHEMA NAME   TBL NAME

User · Answer

Using JDBC in Java      String quer  quot SELECT   FROM sample2 where 1 2 quot            Statement st con createStatement        ResultSet rs st executeQuery quer       ResultSetMetaData rsmd   rs getMetaData        int NumOfCol 0      NumOfCol rsmd getColumnCount        System out println  quot Query Executed   No of Colm  quot  NumOfCol

User · Answer

SELECT TABLE SCHEMA       TABLE NAME       number   COUNT     FROM INFORMATION SCHEMA COLUMNS GROUP BY TABLE SCHEMA  TABLE NAME    This one worked for me

User · Answer

Following query finds how columns in table -   SELECT COUNT COLUMN NAME  FROM USER TAB COLUMNS  WHERE TABLE NAME    TableName

[sql] Find the number of columns in a table

Examples related to sql

Examples related to mysql