How to select all the columns in the table - Need an optimised query

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

David Poole-249495 Ten Centuries Points: 1106 More actions · Answer 1

To do what exactly?

If you just want a list of fields then SET FMTONLY ON before the query will give you what you need.

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 2

select top 0 * from <table name>

My Blog: http://dineshasanka.spaces.live.com/

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

SSC Guru

Points: 294069

September 19, 2005 at 6:25 am

Select * from dbo.TableName where 1 = 0

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 4

Not recommended but another approach

SELECT SO.[name], SC.colorder, SC.[name]

FROM (SELECT [id], [name] FROM sysobjects WHERE xtype = 'U') SO

INNER JOIN syscolumns SC ON SO.[id] = SC.[id]

WHERE SO.[name] = 'YourTableNameHere'

ORDER BY SO.[name], SC.colorder

Good Hunting!

Kayal Right there with Babe Points: 750 More actions · Answer 5

Right there with Babe

Points: 750

September 19, 2005 at 9:58 pm

Thanks Guys!!!!!!!!!!!

Koppisetti Neeraja SSC Rookie Points: 32 More actions · Answer 6

You could use this query:

select name, colorder from syscolumns where object_name(id) = 'yourtablename'