How to locate names of all columns in a table?

I found the following query is very much worth-full when you are looking for names of all columns in a table SELECT (o.name) AS [Table Name], o.type, c.name AS [Col Name], s.name AS [Col Type], c.prec, c.scale, c.isnullableFROM dbo.sysobjects AS o INNER JOIN dbo.syscolumns AS c ON c.id = o.id INNER JOIN dbo.systypes AS s…

March 24, 2008 | by

I am Echinacea

I am anEchinacea What FlowerAre You? Last day, I have visited this site and got as ‘I am Echinacea’. Check which flower you are?

March 24, 2008 | by

My First Post

This is a newer one blog of mine.With the great response of my another blog and site I have decided to utilize some more hours to do this task.

March 24, 2008 | by