How can I get the index number of any column in an SQL database?

Question

SQL:

Select ROW_NUMBER() OVER(Password) From Student

Relevant: [The column order is just a "cosmetic" thing we humans care about - to SQL Server, it's almost always absolutely irrelevant....There is no SQL command to define the column ordering.](https://stackoverflow.com/a/1605167/5894241) — Nisarg Shah, Sep 28 '17 at 12:37
Why? What are you trying to accomplish? What problem are you trying to solve? For what reason can you not simply look at the output and count? — David, Sep 28 '17 at 12:38
Your edit indicates something completely different from before the edit. Please explain in words, not code, what you want and why. — HoneyBadger, Sep 28 '17 at 12:44
That doesn't help a lot, I still don't know what you expect. What is this "index number"? — HoneyBadger, Sep 28 '17 at 12:45
how can get position of a particular column in table. like 150 column in table and i want access password column through their position so how can i do ? — Satyanand bhardwaj, Sep 28 '17 at 12:47
Please add this information to the question. Thanks in advance. — Peter Mortensen, Sep 30 '17 at 10:13

HoneyBadger · Accepted Answer · 2017-09-29T10:34:18.973

1

Most, but not all (I think Oracle is one which doesn't) database systems implemented the INFORMATION_SCHEMA which you can query to get information about database objects. In order to get the ordinal position of a column in a table, you can use:

SELECT      C.ORDINAL_POSITION
FROM        INFORMATION_SCHEMA.COLUMNS AS C
WHERE       C.TABLE_NAME = 'Table'
        AND C.COLUMN_NAME = 'Password'

I can't help wonder why you need this information though...

edited Sep 29 '17 at 10:34

answered Sep 28 '17 at 13:55

HoneyBadger

14,750
3
34
48

Yes sir I found column number of 'Password' field – Satyanand bhardwaj Sep 29 '17 at 08:44

How can I get the index number of any column in an SQL database?

1 Answers1