Re: how to get DDL for a table in SQL Server
Brady Kelly <[email protected]>
| Newsgroups | gmane.comp.windows.devel.dotnet.winforms |
|---|---|
| Organization | Chase Software |
| Message-ID | <[email protected]> |
In SQL 2000, in the SQLDMO objects there was a method somewhere to get the script for an object. > -----Original Message----- > From: Discussion forum for developers using Windows Forms to build apps > and controls [mailto:[email protected]] On Behalf Of > samir parekh > Sent: 26 April 2007 10:57 AM > To: [email protected] > Subject: [DOTNET-WINFORMS] how to get DDL for a table in SQL Server > > 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.