Solved

How to get CREATE table script using TSQL

Posted on 2013-06-06
6
597 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

726 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