Professional Web Applications Themes

number columns - Microsoft SQL / MS SQL Server

If you want to know the number of columns of a table, you have 2 sources of information. [A] You can use the "syscolumns" system table. [B] You can use the "information_schema.columns" view. -- HTH, SriSamp Please reply to the whole group only! http://www32.brinkster.com/srisamp "Itzik" <co.il> wrote in message news:phx.gbl... ...

  1. #1

    Default Re: number columns

    If you want to know the number of columns of a table, you have 2 sources of
    information.
    [A] You can use the "syscolumns" system table.
    [B] You can use the "information_schema.columns" view.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "Itzik" <co.il> wrote in message
    news:phx.gbl... 


    SriSamp Guest

  2. #2

    Default Re: number columns

    Hi Itzik,

    Try the following:
    USE Northwind
    SELECT COUNT(column_name) FROM information_schema.columns
    WHERE table_name = 'Employees'

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Itzik" <co.il> wrote in message
    news:phx.gbl... 


    Jacco Guest

  3. #3

    Default Re: number columns

    pResultset->GetFields()->GetCount();

    "Itzik" <co.il> wrote in message
    news:phx.gbl... 


    Jonathan Guest

  4. #4

    Default number columns

    How can i know how much columns have specific table ?

    Thanks


    Itzik Guest

Similar Threads

  1. Replies: 5
    Last Post: December 12th, 10:29 PM
  2. How to the get to number of retrieved columns?
    By Roman Klimkowicz in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: September 18th, 11:30 PM
  3. How to get the number of retrieved columns when doing a SQL Query
    By Roman Klimkowicz in forum ASP.NET Data Grid Control
    Replies: 4
    Last Post: September 16th, 01:15 PM
  4. number of columns
    By atse in forum ASP
    Replies: 16
    Last Post: October 8th, 03:32 AM
  5. Unknow number of columns in repeater
    By Antonio Maciel in forum ASP.NET General
    Replies: 3
    Last Post: July 2nd, 09:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139