Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
May 16, 2000

SQL Server Datatypes

Question:
Why doesn't the datatype called sysname show up in all the tables' dropdown lists of datatypes?

Answer:
The sysname datatype is a system datatype used to store database object names such as table columns, variables and stored procedure parameters. This is a user-defined datatype based on the nvarchar datatype and is used only in system tables, which is why you don't see it when you are creating table columns.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date