Export Schema in SqlServer 2005

Hi all,

sorry for the rather trivial question but I couldn't figure this out by
myself.

How do you export a db schema either from the commandline or from the
GUI (if I remember correctly it's called Management Studio in the new
version).

Thanks in advance,
LorenzoIn Enterprise Manager:
1) open the databases folder
2) highlight the database you want to generate a SQL script for
3) right-click and select "All Tasks..."
4) select "Generate SQL Script"
the "Generate SQL Script" window pops-up.

At this point, I usually just click on the "select all" button near the
top-right corner. You can select objects individually for scripting at
the bottom-left sectio of the window or, at the top-left section, you
can select "all tables", etc.

hth,

victor dileo|||vjdileo wrote:
> In Enterprise Manager:
> 1) open the databases folder
> 2) highlight the database you want to generate a SQL script for
> 3) right-click and select "All Tasks..."
> 4) select "Generate SQL Script"
> the "Generate SQL Script" window pops-up.

Hi Victor,

thanks for your reply... guess that All Tasks didn't say anything good
to me! ;)

Lorenzo