Manipulate column names in a SQL Server table

by:
Roman Rehak

Learn SQL Server commands to manipulate column names in a table and turn column names into variables or rename SQL columns.

I have two questions regarding how to manipulate column names in SQL Server. Is there a command to turn the names of columns in a table into variables, and is there a command to rename columns, as well? I have attempted the latter, but it does not work in conjunction with Visual Basic programming.

You can use the following query to get a list of columns for a given table and use it to populate variables:

Step 2 of 2:

By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

Safe Harbor

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns
WHERE TABLE_NAME = 'Address'

You can rename a column using the following example:

EXECUTE sp_rename N'dbo.aaa.NewColumnName', N'NewColumnName2', 'COLUMN'

You can execute it from VB.NET, as well, by using the SqlCommand object and setting the CommandText property to the SQL code you want to execute. For a similar example, look at this expert answer on restoring SQL Server databases in VB.NET.

This was first published in October 2008

Step 3: Consider using implicit transactions

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

E-Handbook

Pricing out the new Windows Azure SQL Database
E-Handbook

Developments in SQL Server BI point to focus on self-service, users

Related Q&A; from Roman Rehak, Contributor

Tips for tuning SQL Server 2005 to improve reporting performance

There are a few things you can do to tune SQL Server for improved reporting performance. Here are some generic and Reporting Services-specific ...continue reading

Storing and searching for image files in SQL Server

Learn about working with image files in SQL Server, including advice on using queries to locate them, in this expert answer.continue reading

Licensing a standby server for SQL Server replication

Is a license needed for a standby server if it's used for SQL Server replication? Get that answer and a comparison of SQL Server log shipping to ...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

Bring data analysis methods to the masses

Many members of the general public, which includes business executives, don't really understand what analytics is all about. It's...

Setting the stage to effectively visualize data

The piles of data gathered from business intelligence and analytics tools is of little use to BI, data management and IT teams if...

Self-service analytics needs strong data architecture foundation

The adoption of self-service BI and analytics tools continues to grow. But understanding how to support their use is a must -- ...

SearchDataCenter

What's yours is mine: Sharing DCIM

It's hard to avoid the growing importance of data center infrastructure management technology (DCIM) within the world of IT. Data...

Address common problems in mainframe testing concepts

Accurate mainframe testing data is hard to obtain. This overview covers testing concepts, problems and tool options for improving...

Avoid common server racking issues

Increasing physical demands of modern IT gear can pose problems for classic rack enclosures. Watch for these factors when buying ...

SearchDataManagement

Key considerations for determining if a NoSQL DBMS meets your IT needs

NoSQL represents the fastest-growing type of DBMS being adopted today. Is it right for you?

Couchbase, VoltDB pursue more database scalability in big data apps

New database updates address large-scale applications. Included are Couchbase Server 4.0 with multidimensional scaling support ...

CDO jobs on the rise to help wring more business value out of data

Chief data officers are becoming more prevalent in companies, and more necessary, consultant John Ladley said in a webinar -- so ...

SearchAWS

Survive and thrive in cloud DevOps

Research shows that more companies are adopting DevOps, or the blending of an organization’s application development and systems ...

Amazon job listings offer many AWS roadmap clues

Amazon is hiring thousands of people, and where it’s hiring offers clues about where the AWS roadmap is headed.

Supporting Internet of Things applications in AWS

AWS has tools to help manage Internet of Things devices and apps, but PaaS database architectures could better handle IoT's large...

SearchOracle

Federal Court returns patent lost in Google vs. Oracle case

During the Google vs. Oracle court case, a lower court ruled to invalidate an Oracle patent. Now, a federal court has given ...

Oracle Marketing Cloud uses big data to help higher ed

Oracle releases Oracle Marketing Cloud products for colleges and data-as-a-service users, and a judge decides to keep the Oregon ...

Constant currency-tinted lenses make for a better looking Q3

Oracle's third-quarter financial results look very similar to last year's, but with constant currency the picture is much ...

SearchContentManagement

Using IoT technologies to fuel interconnected experiences

IoT technology and mobile apps generate new concerns, including how to create interconnected digital experiences for users.

Is SharePoint in the cloud the right fit for your company?

SharePoint Online can reduce costs and ease management headaches, but not without a few functionality tradeoffs. Companies should...

Grant supports open source path to manage digital assets

Digital asset management software helps museums manage burgeoning digital collections, but at high cost. A new open source DAM ...

SearchWindowsServer

This PowerShell module takes control of NTFS permissions

One simple install of the File System Security PowerShell Module can help manage NTFS permissions for user access to folders.

Five must-read Windows administrator books

With plenty of titles on the market, it's tough to whittle down a reading list. Our expert has made a list of required reading.

Windows Server networking improvements and changes

The next version of Windows Server will see the end of network access protection, but more networking enhancements can be found ...

Dig deeper on SQL-Transact SQL (T-SQL)

E-Handbook

E-Handbook

Related Q&A; from Roman Rehak, Contributor

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: