Does SQL Table Column is assigned with column number
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.