Export an entire database schema SQL 2000 SP4

All,
I need to create a copy of an existing database on the same server. Due to space limitations I only want to take the schema and then import certain tables. Is there a way to export / import the schema for a database, i.e. no rows required?
Thanks
LVL 5
NetstoreAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
Generate the script and run it on the new database
You can use IMPORT/EXPORT Wizard to copy the tables
0
 
SireesConnect With a Mentor Commented:
You can use the Import / Export Wizard to create a new database and all the
database objects (tables views, stored procedures) WITHOUT copying data, but
I believe it won't copy roles or users.
0
All Courses

From novice to tech pro — start learning today.