Export Table Creation DDL with Column Descriptions

Toad Data Point & Toad Intelligence Central
1

I’m using the Export->DDL tool to create a generation script for a group of tables.

The generated script contains the table creation, indices, pks etc etc, but I can’t seem to get the generator to include the column descriptions into the script.

How do I include the table and column descriptions?

Tony

2

Sounds like an omission on our part. What database type are you connected to?

3

MS SQL Server 2012.

Excuse my omission.

4

I went to open an issue on this and I realized I am not sure exactly where you are in the product. I can think of three places that generate DDL. None of them include comments.

  1. The Script tab on the View Details window.

  2. The Generate SQL | Create Script

  3. Export Wizard using SQL Script with DDL

Which one did you mean?

5

This issue was found in choice #3. Export Wizard using SQL Script with DDL

6

Attach a copy of your SQL script.

7

You mean the Export->DLL-> Output?

Attached
Example_Table_Export_No_Description_Feb17, 2015 12_51_34.sql (17.5 KB)

8

In case you are wondering this is Toad for SQL Server, Version 6.5.0.2

Now that I look back at this thread I wonder why I was asked how did I generate the output.

The first line of my first posting was ‘I’m using the Export->DDL tool’. So why did Debbie ask this question?

Tony

9

I ask because I don’t recognize Export | DDL. I think you are talking about the menu action below. That feature doesn’t exist in Toad Data Point, only Toad for SQL Server. I can forward thist post to that team but it really should be on their forum as they will need to fix it.

ExportDDL.png

10

Can I get an update on this issue/problem?

Did you forward the problem to Toad for SQL Server group? Did they have a response?

Are you telling me since I posted this to the wrong board/group - isn’t it all Toad ? - that I have to file it again to get a response?

Tony

11

I will ask someone from that team to pick up these thread.

12

Hi Tony,

You can select "Script exetended properties" in export DDL options to include ms_descriptions for table and columns. See attached screenshot.

Thanks,

Vincent

ms_desc.jpeg
ms_desc.jpeg633×577 95.9 KB

13

Thanks Vincent.

That works and solves my issue.

Tony