Changing Column Positions

Rating:

(0)

Brian Moran

SQL Server Magazine

InstantDoc ID #41990

I can change the ordinal position of a column in a table by changing the value for colid on columns in the syscolumns tables. But I get an error message when I then try to create an index using the column whose position I've changed. Is there a way to change the ordinal position of a column in a table without recreating the table?

Mod...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

There are no comments to display. Be the first one!

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

SSIS Performance Tuning, Connecting to Heterogeneous Sources, and Complex Transformations
A White Papers by expressor software

The Essential Guide to Mission-Critical Microsoft SQL Server
A Essential Guides by EMC

Tuna Helper - Tuning SQL Statements: A Proven Process for SQL Server Environments
A White Papers by Confio

A Business Case for Lowering Enterprise Total Cost of Ownership - Microsoft SQL Server for SAP on HP Integrity Servers
A White Papers by Hewlett-Packard

Paid Case Study of Sr. IT Professionals in $1B+ companies who migrated from Sybase/ Oracle to SQL Server 2008

Pique Solutions (www.piquesolutions.com), a premier consulting firm working with Fortune 500 technology vendors, is developing a video Case Study on b...