April 16, 2019 at 12:00 am
Comments posted to this topic are about the item Create Table DDL via TSQL
Lowell
April 16, 2019 at 7:45 am
Hi, thanks for the good article.
But i tried downloading the compressed file, but it did not download.
Regards.
April 16, 2019 at 10:53 am
San_kan1gb;
I believe this article was reposted from the original~12 years ago, i'll see if i can recover the links. the proc has gone through a slew of changes since then..matching the created case of all objects, and a ton of improvements.
grab the code snippets form page 8 of this thread: it houses the most updated versions of this code.
https://qa.sqlservercentral.com/forums/topic/get-ddl-for-any-sql-2005-table/page/8
there are things this code does not do, temporal tables , in memory optimized, partitioned tables, tables with custom data type names over 16 chars, and a few other exotics, like xml indexes.
let us know if you have any questions in that other thread.
Updated yet again...same old links but new code.
Lowell
April 16, 2019 at 2:49 pm
I've downloaded those files and added them to the article in a zip file.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply