SQL Query to Get Column Number OR Position

SELECT COLUMN_NAME, ORGINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=’TestData’

Output:

COLUMN_NAME	ORGINAL_POSITION
ID	1
TestID	2
TestCaseDesc	3

Advertisements