1. 

   viron86 Active Member

   Messages:

   426

   Likes Received:

   6

   Best Answers:

   0

   Trophy Points:

   60

   #1

   can we count number of columns in a table
   i want to know ..............can i count the number if columns are already exist in a table+oracle
   

    

   viron86, Nov 26, 2008 IP
   
2. 

   drew22299 Guest

   Messages:

   76

   Likes Received:

   3

   Best Answers:

   0

   Trophy Points:

   0

   #2

   Try this query:
   
   SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMN WHERE TABLE_NAME in ('yourtablenamehere')
   
   Here is the link to the information
   
   http://forums.devshed.com/ms-sql-development-95/sql-count-columns-449206.html

    

   drew22299, Nov 26, 2008 IP

• Log in with Facebook

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in