Maximum field name(column) length in SQL Server

Question

Hi everyone i'm trying to create a table with columns that is more than 128 of text.

is it possible to increase the field name(column) length in SQL Server

Maximum length of the `SYSNAME` data type is 128 http://stackoverflow.com/questions/5720212/what-is-sysname-data-type-in-sql-server — Tim Schmelter, Nov 24 '15 at 08:51
128 is already a lot. May I ask why do you need something longer? — Julien Vavasseur, Nov 24 '15 at 08:53
we will use the questions in surveys as the column name, so if we have 10 questions, 2 of it is for narrative(this is the problem i need to solve, the questions for narrative are sometimes very long and we can't create a solution that is hard coded) — Yukimoto Otomikuy, Nov 24 '15 at 09:01
We will use the field names(Column) as a value,legend in PowerBI. do you have any solution for this? — Yukimoto Otomikuy, Nov 24 '15 at 09:17

score 0 · Answer 1 · answered Nov 25 '15 at 11:30

0

Were you looking for something like this?

ALTER TABLE YourTable ALTER COLUMN YourColumn nvarchar(256) NULL

You could put in it any number below 4000 otherwise go for nvarchar(max)

answered Nov 25 '15 at 11:30

Simone

score 0 · Answer 2 · answered Jan 14 '21 at 13:43

0

Your best option would be to use the PIVOT function in SQL Server, and keep the questions numbered 1,2,3 etc. Great example of this is available here

answered Jan 14 '21 at 13:43

Northernlad

2 Answers2