Book a Demo

Author Topic: Generate DDL to Store Comments in SQL Server?  (Read 3226 times)

DMT

  • EA User
  • **
  • Posts: 93
  • Karma: +0/-0
    • View Profile
Generate DDL to Store Comments in SQL Server?
« on: June 09, 2003, 10:46:14 am »
I have started using the DDL generation support to generate tables.  I was all excited to see support for generating comments, but then I realized that all it does is place the comments in the generated text file!  

It doesn't do what I expected, which was generate the appropriate SQL to add the comments into the database, so they'd be viewable in Enterprise Manager when I go view the table design. Once the table is generated, no one is going to be looking at the script--they'll be looking directly at the database.

Does anyone know if this is possible?  And if not, if there are any plans to add this support in some form or fashion?