i searched but could not find
please help
what is the maximum characters allowed for a column name?In SQL Server, all database object names (including columns) are called
identifiers. See the Books Online topic "Identifiers" in which it states the
following:
"Both regular and delimited identifiers must contain from 1 through 128
characters. For local temporary tables, the identifier can have a maximum of
116 characters."
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Abraham Andres Luna" <abe@.rdk.com> wrote in message
news:u5jqCed%23FHA.2384@.TK2MSFTNGP15.phx.gbl...
>i searched but could not find
> please help
> what is the maximum characters allowed for a column name?
>|||ty for your answer|||Of course, any column name > 30 characters is assumed to be the result of a
stuck keyboard key.
"Abraham Andres Luna" <abe@.rdk.com> wrote in message
news:uk2yUyd%23FHA.2300@.TK2MSFTNGP10.phx.gbl...
> ty for your answer
>
Wednesday, March 7, 2012
maximum column_name length
Labels:
characters,
column,
column_name,
database,
findplease,
helpwhat,
maximum,
microsoft,
mysql,
oracle,
searched,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment