MSSQL Column Name Size

Posted on 2004-09-30
Medium Priority
Last Modified: 2012-06-21
I'm looking fora way to increase the Column Name size in MSSQL which is currently limited to 128 char. I'm trying to auto create TABLE with variable column name in MSSQL. Thus the column name length will be more than 128. Is there a way?
Question by:tuckkhai

Expert Comment

ID: 12188725
I am unsure, I know some other systems such as sybase have a 255 character field name limit, but I would have thought that whatever this limit is it would be unchangable.

Depending on what you are trying to do, it seems like a 128 character column name could prove extremely unwieldy whenever you try to get information back out - why exactly are you trying to achieve by doing this?

Author Comment

ID: 12188768
I'm trying to transfer the data of OLAP cube into flat table. Thus, the column name will be the dimension unique name. I have to use unique name due to that the same name may occur in different level of the cube. So, i really hoping to get a solution for this. Thanks
LVL 12

Accepted Solution

geotiger earned 400 total points
ID: 12189690
I really discourage you to use column names longer than 128 chars. You could use none-discriptive column names in tables and display the discriptions for columns in OLAP. You just need to create a meta data about your tables with description for each of your columns. I am not sure whether this can be done in mySQL, but I have done this using Brio's OnDemand server with Oracle.
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

LVL 34

Expert Comment

ID: 12192301
I agree--anything that large is almost not usable by an end user or many reporting applications....If you really need something like this, create a cross reference table that references the "chopped" column name with the long OLAP column name.

Author Comment

ID: 12196389
I'm interested in the Meta Data concept by geotiget. I'm not using MySQL but using Microsoft SQL Server(MSSQL). I'm had thaught about the cross reference table commented by arbert, but i'm looking at something better, something like the metadata concept proposed by geotiger.
LVL 34

Assisted Solution

arbert earned 400 total points
ID: 12197172
The metadata that SQL Server supplies (at this point) is very good--you get descriptions that you add via an extended stored proc and that's about it.  That's why I suggested a cross reference table  this way you can also collect any of the additional information you require.

Good modeling tools also allow you to collect meta data.  There are also third party applications that specifically handle metadata.

But, at this point, I wouldn't rely on built in SQL Server functionality to handle meta data....

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

586 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question