Stored procedure for displaying field names

Display field names from a SQL Server database with this stored procedure shared by our development expert Greg Low.

Greg Low

Published: 16 Aug 2006

Could you give me a stored procedure for displaying field names from a SQL Server database?

You can do this easily by using the INFORMATION_SCHEMA views. Take a look at the output from:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
Select the appropriate columns you want in the stored procedure.

Dig Deeper on SQL Server Stored Procedures

Related Q&A from Greg Low

Should developers have permissions to SQL Server production queue?

Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ... Continue Reading

Schedule stored procedure and save output to network drive

Find how to save stored procedure output to the network drive via SQL Server Management Studio. Continue Reading

Query to find SQL Server database names created by users

Find how to query in SQL Server to get all database names created by users. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Sigma analytics platform's interface simplifies queries

Featuring a spreadsheet interface designed to make queries simple for citizen data scientists, Sigma Computing is trying to make ...

How to compare and choose augmented analytics tools

Choosing an augmented BI and analytics vendor can be difficult when their offerings are so similar. Analysts at Gartner and ...

ThoughtSpot IPO could be coming after vendor adds first CFO

Hiring of a CFO for the first time signals that ThoughtSpot may be positioning itself for an IPO and comes six months after what ...

SearchDataCenter

A guide to data center maintenance outsourcing

Data centers have a lot of moving mechanical parts to maintain. It's beneficial to leave electrical and fire system upkeep to the...

Top data center skills admins can use in 2020

The 2019 tech job sector saw consistent growth and job availability. In 2020, admins should develop expertise on cloud ...

Organizations try to predict the effect of 5G infrastructure

With more 5G and IoT devices emerging, admins must prepare their data centers to support low-latency apps and edge computing with...

SearchDataManagement

Hitachi Vantara acquires data catalog vendor Waterline Data

With the acquisition of Waterline Data, Hitachi Vantara is bringing new data catalog capabilities that will expand the Lumada ...

New Confluent Platform release boosts event streaming quality

Based on the open-source Kafka event streaming platform, the Confluent Platform 5.4 update adds new capabilities to help meet ...

Where InfluxDB time series database is going

Users need more than SQL for querying databases, according to Paul Dix, co-founder and CTO of InfluxData. That's why the vendor ...

SearchAWS

New themed Amazon pop-up stores built on consumer data

In its never-ending quest to establish unique physical locations, Amazon has plans to launch a chain of themed pop-up stores that...

AWS security faces challenges after a decade of dominance

After a decade of dominating the public cloud market and influencing cloud security, AWS is faced with new challenges stemming ...

AWS AI tools focus on developers

AWS sells many AI products, tools and services aimed at developers, including several for AI newcomers, such as DeepRacer, ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchContentManagement

4 popular content collaboration platforms to consider

Companies need to be organized if they want to be efficient. Content collaboration platforms are useful, but first, ensure that ...

AI can enhance content security with a bit of planning

Microsoft and Box both use AI technologies to keep content secure in the cloud. But before using such tools, businesses first ...

Ex-SAP exec steers Episerver CMS toward digital experience market

Alex Atzberger discusses leaving the helm of SAP's CX platform to become Episerver CEO. Now, Episerver looks to reinvent itself ...

SearchWindowsServer

Using Azure AD conditional access for tighter security

The cloud-based identity and access management service does not come with certain defensive features turned on by default, which ...

PowerShell 7 features admins should examine

The next version of the administrative tool introduces several features, including a new cmdlet to assist with troubleshooting ...

Battle lines over Windows Server 2008 migration drawn

Microsoft and AWS stepped up their ongoing battle promoting a variety of Windows Server 2008 migration tools in hopes of luring ...

Dig Deeper on SQL Server Stored Procedures

In-memory OLTP reborn with SQL Server 2016

Troubleshoot SQL Server database performance with T-SQL

Nine T-SQL best practices

Third-party tool for SQL Server outshines IntelliSense in SSMS

Related Q&A from Greg Low

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.