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

All
News
Get Started
Manage
Problem Solve

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

Promethium tool taps natural language processing for analytics

The software, called Data Navigation System, was designed to enable non-technical users to make complex SQL requests using plain ...

Intelligence as a service is key to nonprofit's urban planning

Cobalt Community Research, a nonprofit organization based in Michigan, uses data collected and packaged by TruFactor for urban ...

GoodData BI customers now able to use data on Amazon Redshift

GoodData partners with Amazon Web Services to allow the vendor's users to store and manage their data in Amazon Redshift, a cloud...

SearchDataCenter

IBM quantum computers' usefulness in sight -- using binoculars

IBM's Bob Sutor discusses Big Blue's new quantum systems and computation center, the realities of quantum computing today and how...

Addendum sets ASHRAE 90.4 as energy-efficiency standard

The publication of ASHRAE 90.4 in 2016 brought a new set of energy guidelines, but the industry still used Standard 90.1. A new ...

How to realize the benefits of software-defined infrastructure

Software-based infrastructure and services can streamline management and application data. Before you add them to your data ...

SearchDataManagement

Data integration vs. ETL in the age of big data

Data integration provides a consistent view of business performance across multiple data sources, though it needs to keep up with...

5 steps to an improved data quality assurance plan

Consultant David Loshin offers tips on developing a data quality strategy that can help identify data errors before they cause ...

DOD CDO shares 7 data management best practices

The DOD's first chief data officer, Michael Conlin, shares tips on how organizations can modernize their data management ...

SearchAWS

Amplify improvements streamline AWS mobile app development

Once just an open source Java library, AWS Amplify is now a full-fledged AWS mobile app development platform. Learn how it works ...

AWS ups the ante to win SAP cloud ERP workloads

New AWS high-memory instances geared for SAP ERP implementations reflect an ongoing push by hyperscalers for these lucrative ...

A go-to AWS migration checklist for DevOps-ready enterprises

Follow this checklist to prepare for a cloud migration and optimize DevOps practices. The steps include advice on tools and ...

SearchOracle

Oracle OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

This guide covers technology developments and other news from the Oracle OpenWorld 2019 conference, plus key trends for Oracle ...

Oracle applications development EVP on Fusion, SaaS and what's ahead

Steve Miranda discusses lessons learned from Oracle Fusion Applications, SaaS, best-of-breed apps vs. suites and Oracle's ...

The roots of Oracle's cloud evolution: A 20-year review

Oracle, like other prominent on-premises software vendors, has traced a long path into the cloud. These 10 events over the past ...

SearchContentManagement

Box cloud content management adds PDF tools, boosts security

Box partners with Adobe in releasing a new set of PDF tools that can be used within Box's content management cloud to enable ...

AI optimizes content management workflows, personalizes CX

AI is poised to revolutionize content management workflows, bringing order to enterprise documents, greater insights into ...

AI CMS workflows create up close and personal experiences

Incorporating AI into the basic building blocks of CMS workflows optimizes content creation and preparation to personalize ...

SearchWindowsServer

Top Office 365 MFA considerations for administrators

A complex password only goes so far to stop a breach. Implementing multifactor authorization can help, but make sure the product ...

October Patch Tuesday resolves 59 vulnerabilities

Microsoft attempts to stamp out printing issues that originated from a faulty out-of-band patch for an Internet Explorer zero-day.

How to plan for an Azure cloud migration

A Windows Server migration into the Microsoft cloud comes with several administrative benefits, but it also means there are new ...

Dig Deeper on SQL Server Stored Procedures

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.