TSQL to view a table's DDL

20 Jul 2006 8:06 PM

JohnnyMagz

I want to script out a table's DDL (create table statement). I can do this
through the GUI, but I don't know how to accomplish this using TSQL. Can
anyone point me in the right direction?

Many Thanks!
- Johnny

20 Jul 2006 8:21 PM

Narayana Vyas Kondreddi

Give this a try: http://vyaskn.tripod.com/code.htm#tblscript

--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

Show quote

"JohnnyMagz" <JohnnyM***@discussions.microsoft.com> wrote in message
news:E6A197E0-96DD-4E4E-82DA-8713278E6E94@microsoft.com...
>I want to script out a table's DDL (create table statement). I can do this
> through the GUI, but I don't know how to accomplish this using TSQL. Can
> anyone point me in the right direction?
>
> Many Thanks!
> - Johnny

20 Jul 2006 8:46 PM

JohnnyMagz

Thanks! I have downloaded the code. I'll give it a go.

--
- Johnny

Show quote

"Narayana Vyas Kondreddi" wrote:

> Give this a try: http://vyaskn.tripod.com/code.htm#tblscript
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>
>
> "JohnnyMagz" <JohnnyM***@discussions.microsoft.com> wrote in message
> news:E6A197E0-96DD-4E4E-82DA-8713278E6E94@microsoft.com...
> >I want to script out a table's DDL (create table statement). I can do this
> > through the GUI, but I don't know how to accomplish this using TSQL. Can
> > anyone point me in the right direction?
> >
> > Many Thanks!
> > - Johnny
>
>
>