Posted by Chandra on 06/01/05 17:02

SELECT sysCol.Name, sysType.name
FROM syscolumns sysCol
INNER JOIN sysobjects sysObj ON sysCol.id = sysObj.id
INNER JOIN systypes sysType on sysCol.xtype = sysType.xtype
WHERE sysObj.name ='<TABLE NAME>'


best Regards,
Chandra
http://groups.msn.com/SQLResource/
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: Code in the database or middle tier (the CLR controversy)
• Prev in forum: Re: Code in the database or middle tier (the CLR controversy)
• Thread view: Re: Finding a column in a database

[Reply to this message]