Interested to Buy Any Domain ? << Click Here >> for more details...
how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 31063 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / harshad
select count(*) from information.schema.columns
where table_name='tablename'
//where tablename is name of your sql table.
//do not prefix table name with .dbo
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the limitations in ssrs on sql server express edition?
What is resultset concur_updatable?
What is difference between order by and group by?
What are the different types of backups that exist?
Can we call future method from queueable?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Does index slows down insert statements?
What is the difference between dbcc indexdefrag and dbcc reindex?
What the different components in replication and what is their use?
What factors you will consider calculating the storage requirement for that view?
What sql server means?
What are scalar functions?
Is it possible to update the views? If yes, how, if not, why?
How you trouble shoot when any job fails
What is the optimization being performed in oracle and SQL Server?
