export database structure

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Xerxes
    #1

    export database structure

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

    Thanks.

    Tags: None
    • Russ Rose
      #2
      Re: export database structure


      "Xerxes" <mfkashani@gmai l.comwrote in message
      news:1171495938 .996070.298470@ h3g2000cwc.goog legroups.com...
      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".


        Comment

        Previous template Next
        Working...