Tuesday, February 16, 2010

Getting columns name from a table in Sql Server

SELECT syscolumns.name FROM sysobjects, syscolumns WHERE sysobjects.id = syscolumns.id and sysobjects.name='Profile'

No comments: