Max. length of a table in SQL 2000

Dear all,
Do you know what is the maximum length of a table name in SQL2000?
Regards,
Kwokho.128 chars
jobi
"Kwokho" <kwokho74@.hotmail.com> wrote in message
news:e#xFDHoUDHA.2240@.TK2MSFTNGP11.phx.gbl...
> Dear all,
> Do you know what is the maximum length of a table name in SQL2000?
> Regards,
> Kwokho.
>|||It is 256 characters.
You can confirm it when you check the structure of the sysobjects table in
every database.
For example,
EXEC sp_help sysobjects
The name column is where the object name resides.
"Kwokho" <kwokho74@.hotmail.com> wrote in message
news:e#xFDHoUDHA.2240@.TK2MSFTNGP11.phx.gbl...
> Dear all,
> Do you know what is the maximum length of a table name in SQL2000?
> Regards,
> Kwokho.
>|||Hi Kim,
The 256 length that is reported by sp_help for the name column in sysobjects
is the size of the column in bytes. The column is of the sysname datatype,
which is equivalent to nvarchar(128). That the size is reported as 256 bytes
is because navarchar takes 2 bytes for every character. The length is 128
characters.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Kim, KeukTae" <zyuuzika@.korea.com> wrote in message
news:OqvHIMoUDHA.2568@.tk2msftngp13.phx.gbl...
> It is 256 characters.
> You can confirm it when you check the structure of the sysobjects table in
> every database.
> For example,
> EXEC sp_help sysobjects
> The name column is where the object name resides.
> "Kwokho" <kwokho74@.hotmail.com> wrote in message
> news:e#xFDHoUDHA.2240@.TK2MSFTNGP11.phx.gbl...
> > Dear all,
> >
> > Do you know what is the maximum length of a table name in SQL2000?
> >
> > Regards,
> > Kwokho.
> >
> >
>