• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • Last Modified:

Max Identifier length in MS SQL Server 6.5

Does anyone know if there is a limit on how many characters an identifier can be in MS SQL-Server 6.5? I'm working with SQL-Server 7 and some of the constraints ar getting quite long names like 40 or 50 characters. Will these work against SQL Server 6.5?

I seem to remember something about the maximum allowed length beeing shorter in version 6.5

Thansk for your help.
0
micja491
Asked:
micja491
1 Solution
 
lozzamooreCommented:
SQL 6.5 states that identifiers can be no longer than 30 characters.
There are also some other rules:
* may contain numbers, chars, and symbols
* must begin with a letter or underscore
* no spaces (unless quoted identifier)

Hope this helps.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now