asked
SP_Helptext for Table Script
Hi, I want view the create script for a table(which is already created) as below create table my_table ( col1 varchar(10), col2 varchar(10), . . . ) I am using **sp_helptext** and it is working for only Views and Stored_Procs. I need similar functionality for view Table Script (with Indexes) Thankx
This web site runs based on your votes. Please indicate all the helpful answers below by clicking on the thumbs up next to them. If any one answer lead to a solution, please indicate this by clicking on the check mark next to that answer.
There are lots and lots of examples of this available online already. Try a google search for "generate create table script sql server". Result #2 is pretty good. If you get stuck implementing any of the suggestions I'm happy to help out.
Right click on database --> Tasks ---> generate scripts ---> select all the tables you want plus some very useful options such as data, keys ....boom
you can do: exec sp_help table-name
18 People are following this question.
