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

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

This was last published in August 2006

Dig Deeper on SQL Server Stored Procedures

All
News
Get Started
Manage
Problem Solve

Related Q&A from Greg Low

Is it possible to find disabled indexes in SQL Server 2000?

If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know. Continue Reading

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

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

Ten KPI templates for your dashboards

KPIs help companies gauge success, but how do you choose the right metrics to create useful reports? Here you'll find 10 KPI ...

Data visualization process demands smart design, accurate data

Well-designed data visualizations can enable executives to make more-informed business decisions, increasing the potential ROI of...

Seven good data visualization practices for visual integrity

Data visualizations need visual integrity to ensure that the data they present can be interpreted correctly. Follow these design ...

SearchDataCenter

Get to know SIEM software basics and benefits

Security information and event management tools give organizations enhanced network management functionality, such as automatic ...

Plexxi buy bolsters HPE composable infrastructure strategy

HPE strengthened its composable infrastructure strategy with the acquisition of Plexxi, a startup that adds a networking element ...

Hadoop cluster configuration best practices streamline workflows

Organizations that deal with a variety of Hadoop configurations can streamline workflows through baseline configuration, tests ...

SearchDataManagement

AP uses data collaboration platform to spread data journalism

Data journalism reporters need tools that deliver quick context for stories on deadline. A data collaboration platform from ...

GPU databases bring greater parallelism to big data processing

GPU databases offer a new way to process data. 451 Research analyst James Curtis discusses where they fit in big data ...

Distributed SQL database wagered on for scalability boost, GDPR

CockroachDB is a distributed database system that seeks to support processing on a global scale, a need that online gambling ...

SearchAWS

Three AWS budget challenges that plague enterprises

Based on their size, companies face unique challenges around budget management in the cloud. Follow this expert advice to keep ...

Implement AWS billing alerts to stay on budget

AWS offers compute power at your fingertips, but cloud resources can quickly drive up costs if users aren't careful. Stay within ...

EC2 features geared toward modest enterprise adoption

AWS infrastructure services now offer more VM control, licensing flexibility and a price cut -- all part of its plan to lure ...

SearchOracle

AI-for-IT-operations tools map Vegas systems to Oracle ERP

Mapping IoT activity and other IT data to Oracle ERP is the task Las Vegas set for FixStream's AIOps platform in an effort to ...

Oracle 18c features give DBAs incremental database capabilities

Oracle Database 18c is really another version of 12c Release 2 with a different name. It doesn't contain major new features, but ...

Cloud workloads see gradual uptake, but miles to go for databases

A picture of steady but not rapid migration to the cloud by Oracle users emerged at Collaborate 18, with database vets saying ...

SearchContentManagement

Five areas to focus on in a SharePoint and GDPR compliance strategy

SharePoint admins need to be ready for the General Data Protection Regulation, too. Expert Reda Chouffani suggests five things to...

Workplace collaboration tool bolsters employee productivity

The benefits of workplace collaboration tools trickle down to employee relationships, company growth, community engagement and ...

New age collaboration tools empower the future of ECM

Document management, file-sharing and ECM platforms might represent 'ancient' 1990s technology, but AI and collaboration tools ...

SearchWindowsServer

The top 5 unheralded Windows Server 2016 features

Windows Server 2016 is still a novel operating system for many administrators. Check out some of its new and enhanced features ...

Will Exchange Server 2019 address admin issues?

As Exchange Server 2019 draws closer, one administrator hopes Microsoft will incorporate some of the feature requests from the ...

How to protect PowerShell credentials in task automation

When administrators use unencrypted credentials in PowerShell scripts, they expose sensitive information. Find out the ways to ...

SQL Server stored procedures vs. CLR stored procedures: Time to migrate?

Check SQL Server database and log file size with this stored procedure

Configure SQL Server Service Broker for sending stored procedure data

Find size of SQL Server tables and other objects with stored procedure

Saying yes, no or maybe to stored procedures

Why use stored procedures?

library

trigger

Change collation to SQL Server 2005 after upgrading databases

Stored procedures: Create and manage standard objects

Stored procedures: Create and delete constraints and indexes

Stored procedure: Investigate related data