export database structure

Hi,
is there a way of exporting database structure not the data in it?

Thanks."Xerxes" <mfkashani@.gmail.comwrote in message
news:1171495938.996070.298470@.h3g2000cwc.googlegro ups.com...

Quote:

Originally Posted by

Hi,
is there a way of exporting database structure not the data in it?
>
Thanks.
>

Right click on DB --All Tasks --Generate SQL Script then choose
appropriate options.

Or

Restore a copy of the database, truncate all tables, make a backup of the
now empty database and use that backup as your db structure "export".