Solved

How to get CREATE table script using TSQL

Posted on 2013-06-06
6
582 Views
Last Modified: 2013-07-02
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
Comment
Question by:Easwaran Paramasivam
  • 3
  • 2
6 Comments
 
LVL 10

Assisted Solution

by:rjanowsky
rjanowsky earned 500 total points
ID: 39228099
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
 
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 39253629
The script that you shared is not readable. Could you please provide the script in readable format?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39254088
Why don't you contact Tim Chapman directly for the script?
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 10

Expert Comment

by:rjanowsky
ID: 39255239
Sorry, but it's not my script. Please contact Tim and ask for the plain sql script.
0
 
LVL 16

Accepted Solution

by:
Easwaran Paramasivam earned 0 total points
ID: 39280849
0
 
LVL 16

Author Closing Comment

by:Easwaran Paramasivam
ID: 39292521
Thanks.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now