Web Reference: Nov 28, 2025 · To return the name of the type, join to the sys.types catalog view on this column. Maximum length (in bytes) of the column. -1 = Column data type is varchar (max), nvarchar (max), varbinary (max), or xml. Apr 26, 2016 · system_type_id is not unique in sys.types because user types can reuse system type. To get a list of unique system types, you can select rows where system_type_id = user_type_id. As a side note, in SQL Server the system tables are deprecated (i.e. syscolumns, sysobjects) and it's recommended as a best practice to use the views instead, sys.columns, sys.objects, etc.
YouTube Excerpt: As a data analyst you need to understand how SQL Server organizes and stores objects like your
Information Profile Overview
Sys Columns System Type Id - Latest Information & Updates 2026 Information & Biography
Details: $2M - $8M
Salary & Income Sources
Career Highlights & Achievements
Assets, Properties & Investments
This section covers known assets, real estate holdings, luxury vehicles, and investment portfolios. Data is compiled from public records, financial disclosures, and verified media reports.
Last Updated: April 5, 2026
Information Outlook & Future Earnings
Disclaimer: Disclaimer: Information provided here is based on publicly available data, media reports, and online sources. Actual details may vary.