Book a Demo
« previous next »
Pages: [1]

Author Topic: How are nvarchar(MAX) columns reverse engineered?  (Read 2936 times)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
How are nvarchar(MAX) columns reverse engineered?
« on: August 11, 2020, 03:55:08 pm »
We have a database we have reverse-engineered.  One of the tables has a column:

Code: [Select]
[Description] varchar(MAX) NULL
When we RE it, the column has the definition (equivalent to):
Code: [Select]
[Description] varchar(0) NULL
After we forward engineer this, the output DDL has the form:
Code: [Select]
[Description] varchar NULL which is obviously defective.

Is it just us?  Can we do anything to get around this?

TIA,
Paolo
Logged
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!
Pages: [1]
« previous next »