SELECT COLUMN_NAME, ORGINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=’TestData’
Output:
COLUMN_NAME | ORGINAL_POSITION |
ID | 1 |
TestID | 2 |
TestCaseDesc | 3 |
SELECT COLUMN_NAME, ORGINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=’TestData’
Output:
COLUMN_NAME | ORGINAL_POSITION |
ID | 1 |
TestID | 2 |
TestCaseDesc | 3 |