backup to restore a blank database

Hi,
I want to backup the tables, stored procedures, and views from a database
without the data in tables. So, I can restore it to a different development
server.
What is the correct syntax on backup and restore for it?
Thanks.There's no TSQL command to backup only DDL. Use the scripting options instead. You didn't mention
version, so I assume 2005. Right-click the database, All Tasks, and from here you can get to the
scripting wizard. Also, there has been some improvements to the scripting in sp2.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"light_wt" <lightwt@.discussions.microsoft.com> wrote in message
news:BD2FD877-52C4-4266-A4C4-F10B7E79801A@.microsoft.com...
> Hi,
> I want to backup the tables, stored procedures, and views from a database
> without the data in tables. So, I can restore it to a different development
> server.
> What is the correct syntax on backup and restore for it?
> Thanks.
>|||Thanks, Tibor.
Opps... :) I am trying to get an empty database from 2000 as well as 2005...
Thanks.|||Well, both Enterprise Manager as well as Management Studio has scripting options.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"light_wt" <lightwt@.discussions.microsoft.com> wrote in message
news:9D7E379E-2505-4C24-B74C-2D98410B8336@.microsoft.com...
> Thanks, Tibor.
> Opps... :) I am trying to get an empty database from 2000 as well as 2005...
> Thanks.|||the script option will only do one at a time. :)
i wish to get all objects in one step, if tables or indexed views, i don't
want any data.|||Open the script wizard, this let you script several objects.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"light_wt" <lightwt@.discussions.microsoft.com> wrote in message
news:0A62DB80-8A95-4256-826F-CF31F4D72ED7@.microsoft.com...
> the script option will only do one at a time. :)
> i wish to get all objects in one step, if tables or indexed views, i don't
> want any data.