# Export Table Creation DDL with Column Descriptions **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [February 12, 2015, 8:21am UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586 "2015-02-12T08:21:35Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![oconnor](https://avatars.discourse-cdn.com/v4/letter/o/2acd7d/32.png) [@oconnor](https://forums.toadworld.com/u/oconnor)\ **Post date:** [February 12, 2015, 8:21am UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/1 "2015-02-12T08:21:35Z")
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 ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [February 13, 2015, 6:11pm UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/2 "2015-02-13T18:11:51Z")
Sounds like an omission on our part. What database type are you connected to? ---
**Author:** ![oconnor](https://avatars.discourse-cdn.com/v4/letter/o/2acd7d/32.png) [@oconnor](https://forums.toadworld.com/u/oconnor)\ **Post date:** [February 16, 2015, 6:44am UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/3 "2015-02-16T06:44:37Z")
MS SQL Server 2012. Excuse my omission. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [February 16, 2015, 7:40pm UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/4 "2015-02-16T19:40:18Z")
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? ---
**Author:** ![oconnor](https://avatars.discourse-cdn.com/v4/letter/o/2acd7d/32.png) [@oconnor](https://forums.toadworld.com/u/oconnor)\ **Post date:** [February 17, 2015, 6:19am UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/5 "2015-02-17T06:19:47Z")
This issue was found in choice #3. Export Wizard using SQL Script with DDL ---
**Author:** ![GregDavis11009](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gregdavis11009/32/122_2.png) [@GregDavis11009](https://forums.toadworld.com/u/GregDavis11009)\ **Post date:** [February 17, 2015, 7:42am UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/6 "2015-02-17T07:42:37Z")
Attach a copy of your SQL script. ---
**Author:** ![oconnor](https://avatars.discourse-cdn.com/v4/letter/o/2acd7d/32.png) [@oconnor](https://forums.toadworld.com/u/oconnor)\ **Post date:** [February 17, 2015, 9:54am UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/7 "2015-02-17T09:54:45Z")
You mean the Export-\>DLL-\> Output? Attached [Example\_Table\_Export\_No\_Description\_Feb17, 2015 12\_51\_34.sql](https://global.discourse-cdn.com/quest/original/2X/1/1375a5bc792d08fac3b8c615ab8ba14613e29098.sql) (17.5 KB) ---
**Author:** ![oconnor](https://avatars.discourse-cdn.com/v4/letter/o/2acd7d/32.png) [@oconnor](https://forums.toadworld.com/u/oconnor)\ **Post date:** [February 17, 2015, 10:00am UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/8 "2015-02-17T10:00:48Z")
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 ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [February 20, 2015, 7:42pm UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/9 "2015-02-20T19:42:15Z")
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](https://global.discourse-cdn.com/quest/original/2X/5/5383fb4fa66ff8d5260252e853b10002ab770898.png) ---
**Author:** ![oconnor](https://avatars.discourse-cdn.com/v4/letter/o/2acd7d/32.png) [@oconnor](https://forums.toadworld.com/u/oconnor)\ **Post date:** [March 3, 2015, 10:36am UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/10 "2015-03-03T10:36:15Z")
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 ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [March 3, 2015, 7:50pm UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/11 "2015-03-03T19:50:26Z")
I will ask someone from that team to pick up these thread. ---
**Author:** ![vliu](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vliu/32/72_2.png) [@vliu](https://forums.toadworld.com/u/vliu)\ **Post date:** [March 3, 2015, 8:29pm UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/12 "2015-03-03T20:29:38Z")
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](https://global.discourse-cdn.com/quest/original/2X/f/f46e94e6148d647f9de973d57aa47e924cc1ee33.jpeg) ---
**Author:** ![oconnor](https://avatars.discourse-cdn.com/v4/letter/o/2acd7d/32.png) [@oconnor](https://forums.toadworld.com/u/oconnor)\ **Post date:** [March 4, 2015, 7:41am UTC](https://forums.toadworld.com/t/export-table-creation-ddl-with-column-descriptions/32586/13 "2015-03-04T07:41:40Z")
Thanks Vincent. That works and solves my issue. Tony