1. Vertabelo
  2. Идеи
0
Завершен

The SQL script generated do not contain the table and column description.

Wavelet Account 10 лет назад • обновлен David Kinmond 3 года назад • 9
I have keyed in description for all tables and columns. When I generate the SQL script, the script does not contain description or comment. This is quite troublesome when I create the table in postgresql, I need to rekey-in all the description again.
ХОРОШО, МНЕ ПОНРАВИЛОСЬ
Рейтинг удовлетворенности
Оценка удовлетворенности от Wavelet Account 10 лет назад
Начат
Agnieszka Kozubek-Krycuń (Chief Scientist) 10 лет назад
We've just started working on generating descriptions/comments in the SQL scripts. The plan is to release it before Christmas. I'll let you know when the feature is available.
Wavelet Account 10 лет назад
That's great! Thanks.
Завершен
Agnieszka Kozubek-Krycuń (Chief Scientist) 10 лет назад
Table and column descriptions are now generated as comments for table/column
Wavelet Account 10 лет назад
When I click "SQL Preview", I still cannot see any column descriptions.

Kindly assist. Thank you.
Agnieszka Kozubek-Krycuń (Chief Scientist) 10 лет назад
You have to check the checkbox "Generate comments for database objects" in the SQL generation settings. See the screenshot. Make sure the focus is not on any tables to see the Model properties panel.



I'm sorry I forgot to write about it in my previous answer.
Wavelet Account 10 лет назад
Ah, okay. Great! Thanks!
Rick Johnston 10 лет назад
Such an awesome feature!!
Christopher Wiencek 6 лет назад

I know this item is 4 years old; however, it no longer appears to function. 

I would suggest that I'm doing something wrong, but I do not get any of my manually entered comments in the SQL scripts. Even with following the above instructions. This is January 9, 2019. 

Has this feature been deprecated? 

My target database is SQLite, but I don't see how that should alter the creation of comments.

I've placed comments on many tables and relationships as a reminder of my thought process. It would be nice if these items appeared in the SQL scripts generated.

Any suggestions as to what might  be an issue with my model?

David Kinmond 3 года назад

Also doesn't appear to work with Redshift, would be interested to know if this has been resolved.

Сервис поддержки клиентов работает на платформе UserEcho