HI,

    SQL Server has a table called Syscolumns which has columns of all 
the tables. Use the following query.

    Select count(*) from syscolumns where id=3D
    (select id from sysobjects where type=3D'u' and name=3D'employee')

Hope this helps,

N.T.GOPALAKRISHNAN
  ----- Original Message -----
  From: Sergio Davi
  To: professional vb
  Sent: Friday, June 22, 2001 9:31 PM
  Subject: [pro_vb] Count Fields in Table of SQL Server 7



  Please

  How do i Count fields in table of Sql Server??


  Sergio Davi S Bezerra
  davi@c...
  sergiodavibezerra@h...
  UIN# 75143339