design of the table   

hi,

how do i write an sql statement to display the design of a table ?
I've done it before, but can't remember how to do it .

eg. table "Student" has fields studentID int, studentName varchar(50), 
studentAddress varchar(100) etc...

If memory serves me correctly, it goes something like 
ie. desc Student

Much appreciated.

cheers
Andrew

date: Thu, 26 Jun 2008 08:02:00 -0700   author:   Andrew

RE: design of the table   

Hi,
I found the answer myself.

    SELECT o.name AS tblName, c.name AS tblColumn
	FROM sysobjects o 
		INNER JOIN syscolumns c 
	ON o.id = c.id
	WHERE o.name = @TableName
cheers

"Andrew" wrote:

> hi,
> 
> how do i write an sql statement to display the design of a table ?
> I've done it before, but can't remember how to do it .
> 
> eg. table "Student" has fields studentID int, studentName varchar(50), 
> studentAddress varchar(100) etc...
> 
> If memory serves me correctly, it goes something like 
> ie. desc Student
> 
> Much appreciated.
> 
> cheers
> Andrew

date: Tue, 1 Jul 2008 05:01:00 -0700   author:   Andrew