data type

IN on table I have a column with this type : ZusatzText
what means ?
What is the lenght of this colunm ?
thanksTry running this sp in QA or go to "Enterprise Manager", expand the server,
expand the db, click on "User Defined data Types".
use your_db
go
exec sp_MShelptype 'ZusatzText', 'uddt'
go
AMB
"tlft" wrote:
> IN on table I have a column with this type : ZusatzText
> what means ?
> What is the lenght of this colunm ?
> thanks|||SQL allows you to define your own user-defined data type, based on a system
type. For instance you might define a data type called ZipCodeType
char(5)... You may then use this type in table definitions.. The intention
is to assist you in providing standard lengths, etc for commonly used fields
in multiple databases and tables.
What you are looking at is probably a user-defined data type.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"tlft" <tlft@.discussions.microsoft.com> wrote in message
news:33732009-785F-4337-BA4D-0D36ADF930BA@.microsoft.com...
> IN on table I have a column with this type : ZusatzText
> what means ?
> What is the lenght of this colunm ?
> thanks