We store a good bit of meta-data about tables and fields in extended properties in SQL Server. For example a field or table might include guidance for analysts on how it should be used in reporting or what other tables/databases is relates to or is sourced from.
How can I include these extended properties in an ERD diagram so that it will be exported properly with the create statements?
Hi John thanks for posting in the Lucid community - I'm happy to help!
This supplemental metadata is not included within the pre-written script provided by the SQL Server export option. Any additional information you'd like to include beyond the attributes within the script will need to be added to the "Create" statements manually including data types indices and foreign keys where applicable.
I certainly understand how it would be powerful for the export tool to automatically include this information within the script however and we're always looking for ways to improve Lucidchart. If you're willing to share would you please add your thoughts and use case details to our feature request form? Ideas submitted here are considered by our development team when prioritizing improvements to Lucidchart. Thanks for your request and apologies for any inconvenience.
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to create an account.
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to log in.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.