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

Problem attaching stored procedure and SQL Server trigger

Learn why using the sp_OACreate stored procedure with a SQL Server 2005 trigger, is likely to result in a permissions problem. Continue Reading

Copy stored procedure between SQL Server 2005 databases

Copying stored procedures between databases on the same SQL Server 2005 can be done through scripting the stored procedures with this method. 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

Museums and data: A powerful combination

With more and more museums using data to inform their decision-making processes, visitors are reaping the benefits by enjoying a ...

5 augmented analytics examples in the enterprise

Here are the top examples of augmented analytics uses that BI vendors support and enable, including data preparation, NLP-based ...

Phocas BI tool proves its value for manufacturers, wholesalers

With its focus on the manufacturing and wholesale distribution industries, Phocas Software has carved out a niche for itself ...

SearchDataCenter

Iran says it's building an AI supercomputer, despite sanctions

In a tweet, Iran said it is building a new supercomputer. Other nations are doing the same because high performance computing ...

IBM Power chip instruction set now open source

IBM opened up its Power server Instruction Set Architecture allowing the open source community to develop more innovative ...

Big Switch updates its Cloud-First Networking portfolio

Big Switch Networks' new products and features aim to help solve issues such as lack of operational consistency, visibility and ...

SearchDataManagement

ArangoDB 3.5 update improves multi-model database platform

ArangoDB 3.5 accelerates its database platform with improved query performance and enhanced data security capabilities, as market...

GDPR, AI intensify privacy and data protection compliance demands

This guide covers the challenges data management teams face on data protection and privacy, particularly with the rise of GDPR ...

SnapLogic boosts its data integration technology with AI

SnapLogic's latest update for its Intelligent Integration Platform aims to make it easier for users to benefit from data ...

SearchAWS

Implement serverless architecture on AWS without Lambda

Serverless on AWS isn't all about Lambda. In fact, many of the services developers use often -- such as S3, Aurora and others -- ...

AWS Lambda alternatives for flexible cloud workloads

Experts share points of comparison for Lambda vs. the competition, and what other options AWS has for elastic computing without ...

Globe and Mail's AWS migration drives digital engagement

Canadian news outlet The Globe and Mail has broadly adopted AWS cloud services in a bid to increase reader engagement and digital...

SearchOracle

How Oracle RPA systems can automate business tasks for users

Robotic process automation software can be integrated into Oracle environments to help strengthen business operations by ...

Oracle Analytics Cloud update unifies BI products, pricing

Oracle Analytics Cloud now offers a consistent UI and all-in-one pricing for Oracle's analytics tools. But an on-premises BI ...

How to create Oracle Multitenant database user accounts

Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new...

SearchContentManagement

Box Shield adds tighter controls for content sharing

New Box security features enable file- and folder-level access control, while admins and security staff get machine-learning ...

Evergage launches Data Warehouse, a BI analytics product

Data Warehouse, Evergage's new BI analytics product, is designed to collect and analyze customer data in an effort to provide ...

Upgrades to Nintex Forms simplifies electronic form creation

The new form designer by Nintex brings user-friendly capabilities to Nintex Forms for both electronic form creation and data ...

SearchWindowsServer

Pester tests help pinpoint infrastructure issues

The Pester testing framework gives IT pros a way to develop sophisticated and consistent testing routines that monitoring tools ...

How to transfer FSMO roles with PowerShell

You might need to shift Active Directory FSMO roles for a few reasons. If you need to do it more than once, there's a way to ...

Azure AD Premium P1 vs. P2: Which is right for you?

Microsoft's cloud-based Active Directory has different features than the on-premises version, and you'll need to do your homework...

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.