none
table column data type [dbo].[Varchar_Value] on 2008 r2 RRS feed

  • Question

  • Hi. I saw this data type  [dbo].[Varchar_Value] in a table definition.  what is that?  selecting @@version I see ...2008 R2.   I looked for synonyms in the same db, master, model, msdb and found nothing.
    Wednesday, January 22, 2020 4:23 PM

Answers

  • Hi db042190,

    Please share a screen shot of it.

    Also, you can check in the Object Explorer: DB -> Programmability -> Types -> User-Defined Data Types

    • Edited by Yitzhak Khabinsky Wednesday, January 22, 2020 4:32 PM
    • Marked as answer by db042190 Wednesday, January 22, 2020 4:45 PM
    Wednesday, January 22, 2020 4:28 PM
  • Hi. I saw this data type  [dbo].[Varchar_Value] in a table definition.  what is that?  selecting @@version I see ...2008 R2.   I looked for synonyms in the same db, master, model, msdb and found nothing.

    It's a user-defined datatype. Run "sp_help varchar_value" to get the definition. You can also see it in sys.types:

    SELECT * FROM sys.types WHERE name = 'varchar_value'


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    • Marked as answer by db042190 Thursday, January 23, 2020 12:33 PM
    Wednesday, January 22, 2020 10:02 PM

All replies

  • Hi db042190,

    Please share a screen shot of it.

    Also, you can check in the Object Explorer: DB -> Programmability -> Types -> User-Defined Data Types

    • Edited by Yitzhak Khabinsky Wednesday, January 22, 2020 4:32 PM
    • Marked as answer by db042190 Wednesday, January 22, 2020 4:45 PM
    Wednesday, January 22, 2020 4:28 PM
  • when I script the table as a create I see this as the 6th column down

    Wednesday, January 22, 2020 4:36 PM
  • Hi db042190,

    As I mentioned earlier, did you have a chance to check in the Object Explorer: DB -> Programmability -> Types -> User-Defined Data Types ?

    Wednesday, January 22, 2020 4:39 PM
  • Hi. I saw this data type  [dbo].[Varchar_Value] in a table definition.  what is that?  selecting @@version I see ...2008 R2.   I looked for synonyms in the same db, master, model, msdb and found nothing.

    It's a user-defined datatype. Run "sp_help varchar_value" to get the definition. You can also see it in sys.types:

    SELECT * FROM sys.types WHERE name = 'varchar_value'


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    • Marked as answer by db042190 Thursday, January 23, 2020 12:33 PM
    Wednesday, January 22, 2020 10:02 PM