Duplicating SQL DB Structure
I was wondering if anyone here knows how to duplicate an MS SQL Server Database, but without the data. I just need the structure. If I was to back up the current database and then do a restore on the back up and rename it, then I'd have a duplicated database. However, I don't want the data that's in it, so what's the best method. Should I use the method I just described and then just clear the tables? We're using SQL Server Enterprise Manager 8.0. There's an import/export function, but I think that will also import the tables, views, AND data into a new database I just created. Any help will be much appreciated.