Does SQL Table Column is assigned with column number In Table, we can see there is number assigned automatically (line number) is the same thing is available for the columns (column number) and how can we get that number?
I need a SQL query to find the column number not the number of columns.
The row number you get in SSMS (I'm presuming you were refering to this number) is not generated by SQL but by SSMS (so it doesn't really exist in your database).
SQL does have a &quot;number&quot; associated with each columns (their IDs) and you could get those with a query like this one:
  select c.column_id from sys.columns c 
  join sys.objects o on o.object_id =c.object_id
  where o.name = 'YourTableName'

I'm not sure it will do exactly what you expect it to do, so if you could specify why you want those columns number, we will be in a better position to give you a clearer answer.