how to get DDL for a table in SQL Server

samir parekh <[email protected]>
Newsgroups gmane.comp.windows.devel.dotnet.winforms
Message-ID <[email protected]>
I want to get the DDL used to create a table in sql server programatically...

ie using a front end of C# winforms...

the problem is ...for views I can use sp_helptext but I dont know what option to use for tables....

Is there any stored procedure which will give me the required results...

regards
samir


---------------------------------
Ahhh...imagining that irresistible "new car" smell?
 Check outnew cars at Yahoo! Autos.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.