---
title: "How to find Column Name Using COL_NAME() Function?"  
description: "How to find Column Name Using COL_NAME() Function?"  
author: "Sushant Mishra"  
published: 2017-09-18  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/23301/how-to-find-column-name-using-col_name-function  
category: "database"  
tags: ["sql server", "sql server 2008"]  
reading_time: 1 minute  

---

# How to find Column Name Using COL_NAME() Function?

```
SELECT COL_NAME(object_id('Sample..SignIn'),2) AS col_name 
```

It takes two parameter table id and ordinal position and column name

Also you can use

```
SELECT    name AS col_name FROM sys.columnsWHERE    object_id=object_id('Sample..SignIN') AND column_id=2
```

\

output

![How to find Column Name Using COL_NAME() Function?](file:///C:/Users/MSCLIE~1/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png)![How to find Column Name Using COL_NAME() Function?](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAATcAAABvCAYAAACJiIccAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwwAADsMBx2+oZAAACtRJREFUeF7tnU9rG0kah/U99hPs2daAdNhvYqwh0F9jwWDvXIwNuwR82jksgUHZS5b4nKPZCM8pCYkIBEJg8484c8qttt7qqlZ1q1rdLbfsUul5Zn6j7urqakVMP7xV7cgDtcRT9WD/VL2xe2Z/MFADkwd6z1HX7lPT582p2q89ZzO8f/9e3dzcEEJ2JCW5vTndz0Xkye3pg4F6YC1kjtuduvYSTx+U+u+f5qP6594VbeT2+fNn9fLlS/X27dvgcULI9mS5cpOqqpCbVF6Visscq2uvEJJbXd8N0yS3L1++qFevXqn5fK6+ffsW7EMI2Z50k1uxX9de5Y063S9PSzdVtZ3+45/qT3/+SynS5lglt69fv6rXr18jNkISyoblVqFU+QXW4m7JX//290Jssu2zSm4itRcvXpjqLXScELJ92ey0tIRUcfvKLLtVpqt9VnIitarYhFVyc1NSWWujciMkjTTIrSyfzg8UfDyhbVJudTStuX369ImHCYQklJLciqelNrl06qaQXaaWXtVm8M5trPj6oUluko8fP5rp6bt374LHCSHbk+XKLVHayI0Qkk6QGyEkyQzkpt+VhD4AQkiaQW6EkCSD3AghSWYQaiSEkG0PciOEJBnkRghJMsiNEJJkBvJtGKQ+oQ+NEBJ/duaHeNcBuRGyvUFuK6hWcaR9Qv+zEXKXQW4r4CZdL3xuJIY0yi27mK3MXhZOCtTdpM+ePTN58uTJUn799V/Bc3YpyI3EkFZy0/8uciFtq5O63C7kgwgg3wmX6Q8odM4uBbmRGLJ25Vat1ErZa5Db/EyNiu+Ccxmp7NIevy0y/uhMze3uurSR2/fv39XsizJ59N8blWm7h87ZpSA3EkMa5VatUp4/f263cmR65vjx44fpv7eX2ZYaAvKZX2a9CMngxr+l5JrkJl9NPpvNzGciYpN25IbcSBzpLDdfZoKsMwkiNqlipP9oNDJttQSlc6myQab/2wN3ILcLLTX5s8u2rLO5rC236xM1lAp2MvXar9XJULcNT9S13zfyIDcSQxrlJjesVChSnbiFdD/uBneL6evKrVS56ePZyE5XR5k6sx3nZ6PFFFYaq+OUpJZ5Y+R9ls5voKlyqyLVW1HFaflJWv9OBpHbcKjjicwJD7kR0jmt5OYjQvORG10qNrf2JP1byc1IxouW0aXxzVyd6fML9xQC8yo7c770d8csbr/6ag4Gzjft9aySm3yFkjxAkGiHGaFJfKSfTNFbCc7I7USdTIbq5Nq2TSdqONFBboR0zq2mpTIVlYrNX1RvLbeSlC6N0MwDBSOeivh0pXU2F+mJBKXqutTisn1byy1wfgOr5CbCWqpgxXKCPFK+yEw/qeRaCc7K7VqEdnJt2qYiuqltt30mMk2Vz2Q4KSR4fTK0n9NQTey5oTYjy+Iz1e3TxbUX4+rz1rieH+RGYkij3B4+fGgWzd1N7K81uVeJSC2fll5ooayx5qanpQOxmxxbVVWJCDOZXnat3Cz++bapjlVyC1HIzSJC28syIzdJaKwiTm7u9WaqxeLvy/qbV9X5/QYTNXVtZjvUZs9zKY070KKzklrreraPDXIjMaSV3HzkxnYPDyQiNFO12amZ9F/naeli2phXWMWaWNFXjrvpqpu65ucUXd26XVBuofPNgVqa5OYqVjM11a+Lyk3/+bXUhOxiz/QXyYXGKlKSihaGmZJOF+1GJLaKKiLycQ8dpIqa6n4yXqgtv8ZEKjN3vhvXXLfyPjpdrxzkRmJIZ7m5aai7sY3crNhuJzdPOCKt4AMFLS97o41sY+khgRZIWWoy3ZVjeZUWOn8VbeTmxGbkVqno5LhUbyK91pWb3pZpnzxcMNPGkmwCFZjL9dSs1w38PqU2qbhkmlup0LzrLrV3vZ4NciMxpJXcijUlffO6uGloPhWdmX4ujXLbEprk5otNBO/aTdWW7ZmHDqZy6yg3s+2kUbTnFVOxxlW0W2kVFZts17X562aTvHJz4zrpScXY+Xr5mC7IjcSQVnKTNTS5OUOv1W2XFGgtN72bzfaM6B1yTH6ExqxT6v6d5FbXLoKSKaFUn6UF/sWDAvcworFNS8l/cFBMQUvt7a/nB7mRGNIot11mldzkKai8SlXmUshNV20S86RUv7aSWySRp7XlHyTuHuRGYghyW8EquckDgsPDw/xpqI2Tm6w9GuGJ/HSkPWa5yY+cmOqsUqGtG+RGYghyW0HXm9RJrC6hc1IMciMxBLmtgJt0vfC5kRiC3FYgNykhZDuD3AAgSUpym/77P4QQkkSW5HaffPjwwW7tJrv+5wfoE+QWEcgNoD+QW0QgN4D+QG4RgdwA+iM9uc3P1Xh8XvnGke0AuQH0B3KLCOQG0B/ILSKQG0B/bIfc5Msrx/Yvdg/GKst/k4wRWdE+tl8b3iQ3czxT59nYG88eu8zU2P0Fctdu+2e2//j80p5b/z7O1zQrcgPojy2Q21yda3Fkzhjmq8XHWiC23Qpmfq6FY34HQwu5+WISoYX6u3Fsf3P56rY5T96HbROK9u4gN4D+iF9udbKotrv9JrnUnWe3My2qvHKTKqwyXmhbXl3/Ip7sOoDcAPoDuRX7tiL0pppL44W25bXFb9JqA3ID6I/dnJb6x4t9GXexXjY/z9pVbvqf8vurjN8B5AbQHwk9UAgIKET1uLcvQnNTzLFMT6Xd71+77b0/HigARMF2yG1HQG4A/ZGw3GSaaaupUvpZH9sEyA2gP6jcIgK5AfQHcosI5AbQH8gtIpAbQH8syS30W2TuMrIutquvANAfQbndF3Lt/339Yydzn587QIpEJzepYEI3f+qhcgPoFyq3SELlBtAvVG6RhMoNoF+6y21+bv4O5iZ+ELaxcpv9ova1BEQEeX5SB78F+sUQea/DX9RV6FggVG4A/dJBbvlfEM+lsjm5razcqsLoKJA7Tcf3RuUG0C9rTEvzb8+4t8qtJIzH6mDws3rk94klVG4A90p0cutSuV399vNiX7ZNVVmerl4d/7RoO/493CbjFpL0helt6z4HQzv+cNG2r7cPDmU83eb12R/qNio3gHtj+yo3I6WFZI5mNf2MWMpyygUWavtdHWkZmbG0JGVsI8diHDkubZ4cDx/b8/V5pr3SR8bpIDcqN4B+2erKrXrsQKqlQnwLKQ10+8HxY3VlRBhq+0M9OsyF9khXYUfH+joiL6kGXWXnX9ft++11fdx+Q+Q9A0B/bF/lFhSGVGOuggr0mz1WR27qWNdmRCaClPP0ePr1SFdo5QrOnWv3/fa6Pm6/IVRuAP2SSOWWTzXdFPXq2E0JrfSKik22Q21ujEFeqekxpIIr1taqU05/Wlq8n0CfDnKjcgPol0Qqt1xobj3OX8wvtRcPFJbbFnKyY8qamQjMHNPR1148ULDvofp+ZN+Nq+VI5QZwf6wht83RWLklHPlzA0B/RCe30I2/C6FyA+gXKrdIQuUG0C9UbpGEyg2gX6jcIgmVG0C/BOV235EbfddeAaBfluQGAJACyA0AkgS5AUCSIDcASBLkBgBJgtwAIEmQGwAkCXIDgCRBbgCQJMgNAJIEuQFAkiA3AEgS5AYASYLcACBJkBsAJAlyA4AkQW4AkCTIDQCSBLkBQJIgNwBIEuQGAEmC3AAgSZAbACQJcgOAJEFuAJAkyA0AkgS5AUCSIDcASBLkBgBJgtwAIEmQGwAkCXIDgARR6v9ylDFcl8xE6wAAAABJRU5ErkJggg==)

## Answers

### Answer by Sushant Mishra

```
SELECT COL_NAME(object_id('Sample..SignIn'),2) AS col_name 
```

It takes two parameter table id and ordinal position and column name

Also you can use

```
SELECT    name AS col_name FROM sys.columnsWHERE    object_id=object_id('Sample..SignIN') AND column_id=2
```

\

output

![How to find Column Name Using COL_NAME() Function?](file:///C:/Users/MSCLIE~1/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png)![How to find Column Name Using COL_NAME() Function?](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAATcAAABvCAYAAACJiIccAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwwAADsMBx2+oZAAACtRJREFUeF7tnU9rG0kah/U99hPs2daAdNhvYqwh0F9jwWDvXIwNuwR82jksgUHZS5b4nKPZCM8pCYkIBEJg8484c8qttt7qqlZ1q1rdLbfsUul5Zn6j7urqakVMP7xV7cgDtcRT9WD/VL2xe2Z/MFADkwd6z1HX7lPT582p2q89ZzO8f/9e3dzcEEJ2JCW5vTndz0Xkye3pg4F6YC1kjtuduvYSTx+U+u+f5qP6594VbeT2+fNn9fLlS/X27dvgcULI9mS5cpOqqpCbVF6Visscq2uvEJJbXd8N0yS3L1++qFevXqn5fK6+ffsW7EMI2Z50k1uxX9de5Y063S9PSzdVtZ3+45/qT3/+SynS5lglt69fv6rXr18jNkISyoblVqFU+QXW4m7JX//290Jssu2zSm4itRcvXpjqLXScELJ92ey0tIRUcfvKLLtVpqt9VnIitarYhFVyc1NSWWujciMkjTTIrSyfzg8UfDyhbVJudTStuX369ImHCYQklJLciqelNrl06qaQXaaWXtVm8M5trPj6oUluko8fP5rp6bt374LHCSHbk+XKLVHayI0Qkk6QGyEkyQzkpt+VhD4AQkiaQW6EkCSD3AghSWYQaiSEkG0PciOEJBnkRghJMsiNEJJkBvJtGKQ+oQ+NEBJ/duaHeNcBuRGyvUFuK6hWcaR9Qv+zEXKXQW4r4CZdL3xuJIY0yi27mK3MXhZOCtTdpM+ePTN58uTJUn799V/Bc3YpyI3EkFZy0/8uciFtq5O63C7kgwgg3wmX6Q8odM4uBbmRGLJ25Vat1ErZa5Db/EyNiu+Ccxmp7NIevy0y/uhMze3uurSR2/fv39XsizJ59N8blWm7h87ZpSA3EkMa5VatUp4/f263cmR65vjx44fpv7eX2ZYaAvKZX2a9CMngxr+l5JrkJl9NPpvNzGciYpN25IbcSBzpLDdfZoKsMwkiNqlipP9oNDJttQSlc6myQab/2wN3ILcLLTX5s8u2rLO5rC236xM1lAp2MvXar9XJULcNT9S13zfyIDcSQxrlJjesVChSnbiFdD/uBneL6evKrVS56ePZyE5XR5k6sx3nZ6PFFFYaq+OUpJZ5Y+R9ls5voKlyqyLVW1HFaflJWv9OBpHbcKjjicwJD7kR0jmt5OYjQvORG10qNrf2JP1byc1IxouW0aXxzVyd6fML9xQC8yo7c770d8csbr/6ag4Gzjft9aySm3yFkjxAkGiHGaFJfKSfTNFbCc7I7USdTIbq5Nq2TSdqONFBboR0zq2mpTIVlYrNX1RvLbeSlC6N0MwDBSOeivh0pXU2F+mJBKXqutTisn1byy1wfgOr5CbCWqpgxXKCPFK+yEw/qeRaCc7K7VqEdnJt2qYiuqltt30mMk2Vz2Q4KSR4fTK0n9NQTey5oTYjy+Iz1e3TxbUX4+rz1rieH+RGYkij3B4+fGgWzd1N7K81uVeJSC2fll5ooayx5qanpQOxmxxbVVWJCDOZXnat3Cz++bapjlVyC1HIzSJC28syIzdJaKwiTm7u9WaqxeLvy/qbV9X5/QYTNXVtZjvUZs9zKY070KKzklrreraPDXIjMaSV3HzkxnYPDyQiNFO12amZ9F/naeli2phXWMWaWNFXjrvpqpu65ucUXd26XVBuofPNgVqa5OYqVjM11a+Lyk3/+bXUhOxiz/QXyYXGKlKSihaGmZJOF+1GJLaKKiLycQ8dpIqa6n4yXqgtv8ZEKjN3vhvXXLfyPjpdrxzkRmJIZ7m5aai7sY3crNhuJzdPOCKt4AMFLS97o41sY+khgRZIWWoy3ZVjeZUWOn8VbeTmxGbkVqno5LhUbyK91pWb3pZpnzxcMNPGkmwCFZjL9dSs1w38PqU2qbhkmlup0LzrLrV3vZ4NciMxpJXcijUlffO6uGloPhWdmX4ujXLbEprk5otNBO/aTdWW7ZmHDqZy6yg3s+2kUbTnFVOxxlW0W2kVFZts17X562aTvHJz4zrpScXY+Xr5mC7IjcSQVnKTNTS5OUOv1W2XFGgtN72bzfaM6B1yTH6ExqxT6v6d5FbXLoKSKaFUn6UF/sWDAvcworFNS8l/cFBMQUvt7a/nB7mRGNIot11mldzkKai8SlXmUshNV20S86RUv7aSWySRp7XlHyTuHuRGYghyW8EquckDgsPDw/xpqI2Tm6w9GuGJ/HSkPWa5yY+cmOqsUqGtG+RGYghyW0HXm9RJrC6hc1IMciMxBLmtgJt0vfC5kRiC3FYgNykhZDuD3AAgSUpym/77P4QQkkSW5HaffPjwwW7tJrv+5wfoE+QWEcgNoD+QW0QgN4D+QG4RgdwA+iM9uc3P1Xh8XvnGke0AuQH0B3KLCOQG0B/ILSKQG0B/bIfc5Msrx/Yvdg/GKst/k4wRWdE+tl8b3iQ3czxT59nYG88eu8zU2P0Fctdu+2e2//j80p5b/z7O1zQrcgPojy2Q21yda3Fkzhjmq8XHWiC23Qpmfq6FY34HQwu5+WISoYX6u3Fsf3P56rY5T96HbROK9u4gN4D+iF9udbKotrv9JrnUnWe3My2qvHKTKqwyXmhbXl3/Ip7sOoDcAPoDuRX7tiL0pppL44W25bXFb9JqA3ID6I/dnJb6x4t9GXexXjY/z9pVbvqf8vurjN8B5AbQHwk9UAgIKET1uLcvQnNTzLFMT6Xd71+77b0/HigARMF2yG1HQG4A/ZGw3GSaaaupUvpZH9sEyA2gP6jcIgK5AfQHcosI5AbQH8gtIpAbQH8syS30W2TuMrIutquvANAfQbndF3Lt/339Yydzn587QIpEJzepYEI3f+qhcgPoFyq3SELlBtAvVG6RhMoNoF+6y21+bv4O5iZ+ELaxcpv9ova1BEQEeX5SB78F+sUQea/DX9RV6FggVG4A/dJBbvlfEM+lsjm5razcqsLoKJA7Tcf3RuUG0C9rTEvzb8+4t8qtJIzH6mDws3rk94klVG4A90p0cutSuV399vNiX7ZNVVmerl4d/7RoO/493CbjFpL0helt6z4HQzv+cNG2r7cPDmU83eb12R/qNio3gHtj+yo3I6WFZI5mNf2MWMpyygUWavtdHWkZmbG0JGVsI8diHDkubZ4cDx/b8/V5pr3SR8bpIDcqN4B+2erKrXrsQKqlQnwLKQ10+8HxY3VlRBhq+0M9OsyF9khXYUfH+joiL6kGXWXnX9ft++11fdx+Q+Q9A0B/bF/lFhSGVGOuggr0mz1WR27qWNdmRCaClPP0ePr1SFdo5QrOnWv3/fa6Pm6/IVRuAP2SSOWWTzXdFPXq2E0JrfSKik22Q21ujEFeqekxpIIr1taqU05/Wlq8n0CfDnKjcgPol0Qqt1xobj3OX8wvtRcPFJbbFnKyY8qamQjMHNPR1148ULDvofp+ZN+Nq+VI5QZwf6wht83RWLklHPlzA0B/RCe30I2/C6FyA+gXKrdIQuUG0C9UbpGEyg2gX6jcIgmVG0C/BOV235EbfddeAaBfluQGAJACyA0AkgS5AUCSIDcASBLkBgBJgtwAIEmQGwAkCXIDgCRBbgCQJMgNAJIEuQFAkiA3AEgS5AYASYLcACBJkBsAJAlyA4AkQW4AkCTIDQCSBLkBQJIgNwBIEuQGAEmC3AAgSZAbACQJcgOAJEFuAJAkyA0AkgS5AUCSIDcASBLkBgBJgtwAIEmQGwAkCXIDgARR6v9ylDFcl8xE6wAAAABJRU5ErkJggg==)


---

Original Source: https://www.mindstick.com/interview/23301/how-to-find-column-name-using-col_name-function

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.