How to get connection.schema("columns",restrictions) in order by ordinal position
-
I want the columns of table in order of their ordinal position. is it possible?
-
I want the columns of table in order of their ordinal position. is it possible?
exec sp_columns '[table name]' If that's too much info then you could try: SQL 2000 SELECT o.name, c.name as columnname FROM syscolumns c INNER JOIN sysobjects o ON o.id = c.id WHERE o.[name] = 'reports' ORDER BY c.colorder SQL 2005 SELECT O.name, C.name as columnname FROM sys.columns C INNER JOIN sys.objects O ON O.object_id = C.object_id WHERE O.[name] = 'reports' ORDER BY c.column_id
Mark's blog: developMENTALmadness.blogspot.com
-
exec sp_columns '[table name]' If that's too much info then you could try: SQL 2000 SELECT o.name, c.name as columnname FROM syscolumns c INNER JOIN sysobjects o ON o.id = c.id WHERE o.[name] = 'reports' ORDER BY c.colorder SQL 2005 SELECT O.name, C.name as columnname FROM sys.columns C INNER JOIN sys.objects O ON O.object_id = C.object_id WHERE O.[name] = 'reports' ORDER BY c.column_id
Mark's blog: developMENTALmadness.blogspot.com
Thank You Mark. It Works. Well Done.