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
- 30625 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / vidit tyagi
SELECT Count(*)As Coloumns
FROM SysColumns
Where ID =
(SELECT ID FROM SysObjects Where Name = 'TableName')
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Explain the properties of the relational tables?
What you can do to delete a table without the delete trigger firing?
Explain the microsoft sql server delete command? : SQL Server Architecture
What types of Joins are possible with Sql Server?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What does it mean to normalize data?
What is self join in sql server joins?
How to drop an existing table with "drop table" statements in ms sql server?
What is dbcc updateusage?
What are the types of lock supported by ?
application server is slow what may be the problem
How to drop existing indexes in ms sql server?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What are the difference between primary keys and foreign keys?
which table keeps the locking information? : Sql server administration
