Where are the options when producing a DDL script for all tables in Management Studio?

microsoft.public.sqlserver.tools

25 Oct 2006 8:01 PM

Michael MacGregor

In Enterprise Manager it was possible to choose different options, such as
whether to include indexes, triggers, etc., but I can't find where I can do
this in Management Studio. I can generate a script with the CREATE TABLE
commands, including the PKs and FKs, but no indexes. How do I get it to
include the indexes?

Michael MacGregor
Database Architect

25 Oct 2006 8:43 PM

Tibor Karaszi

Right-click the *database*, tasks, generate scripts. Here you will se a bunch of options to
customize the script generation, including which object(s) to scripts and whether or not to scripts
indexes.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Michael MacGregor" <nospam@nospam.com> wrote in message
news:ebhFUBH%23GHA.1224@TK2MSFTNGP05.phx.gbl...
> In Enterprise Manager it was possible to choose different options, such as whether to include
> indexes, triggers, etc., but I can't find where I can do this in Management Studio. I can generate
> a script with the CREATE TABLE commands, including the PKs and FKs, but no indexes. How do I get
> it to include the indexes?
>
> Michael MacGregor
> Database Architect
>