• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 615
  • Last Modified:

How to get CREATE table script using TSQL

I would like to get Create table scripts for given set of tables in my Database using TSQL. I know how to generate using SSMS > Table > Script table as > Create. But I would like to get the script using TSQL for an automated process. Please do assist.
0
Easwaran Paramasivam
Asked:
Easwaran Paramasivam
  • 3
  • 2
2 Solutions
 
rjanowskyCommented:
Have a look at this blog entry http://www.techrepublic.com/blog/datacenter/script-table-definitions-using-tsql/431. It might be of some help to you.
0
 
Easwaran ParamasivamAuthor Commented:
The script that you shared is not readable. Could you please provide the script in readable format?
0
 
Anthony PerkinsCommented:
Why don't you contact Tim Chapman directly for the script?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
rjanowskyCommented:
Sorry, but it's not my script. Please contact Tim and ask for the plain sql script.
0
 
Easwaran ParamasivamAuthor Commented:
Thanks.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now