SQL 2005 - How to extract schema?

Hi

I have read the knowledge base and have found some info on my end goal:

• extract / export sql 2005 db schema only no data

Now in the kb article it states that " mylittleadmin" does not allow you to do this directly you can though do a full datbase backup which I have done - so on my site resides a backup (zip) of my full db - if I unpack on my desk top I have a .bak file ....so to my question how do I open and extract the db schema only?

Notes / background

I am having to give a developer the database so that it can be incorporated in a crm Management suite - but I do NOT want to be handing over sensitive info - so obviously I want to hand him the db structure minus the data.

MS management studio 2005 express springs to mind but i cannot find any documentation on how to use this software to extract the schema only!

Any pointers would be greatly appreciated

Nelly

 

...The best way is to use Express locally if you don't have a full version, don't use 2005...
Use SQL Server 2008 Express, it has more features.

Then from the DB tools menu create a script that generates the SQL for recreating the Schema only.

At that point you can pass along the SQL script safely.