how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 28173 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / kishore
select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')
In this querry may name is Tablename
| Is This Answer Correct ? | 58 Yes | 23 No |
Post New Answer View All Answers
Explain the properties of a relational table?
What is dbcc command in sql server?
What is instead of dml trigger?
Describe in brief sql server monitoring ways.
What happens to a trigger with multiple affected rows?
What according to you is the difference between mysql and sql server performance?
What is normalization? What number of normalization shapes are there?
How many triggers are possible per table?
What is difference between index seek vs. Index scan?
Explain use of expression builder.
What is difference between stored procedure and user defined function?
What is nested transaction?
Can we delete data from a view?
can a database be shrunk with users active? : Sql server administration
what's the maximum size of a row? : Sql server database administration
