Scripting all the constraints and indexes without the create table statement

Posted by Ice on Stack Overflow See other posts from Stack Overflow or by Ice
Published on 2010-01-25T17:23:00Z Indexed on 2010/05/20 16:50 UTC
Read the original article Hit count: 195

Filed under:
|

Hi there,

How to get a script for all tables about all default constraints and indexes from an existing database?

SQL Server Management Studio produces SQL-Scripts with the create table statements and there is no option to dismiss it.

Peace

Ice

© Stack Overflow or respective owner

Related posts about sql-server-2008

Related posts about scripting