SQL Server: dump/export database indexes

djmepvbi 于 2023-03-11 发布在 SQL Server

关注(0)|答案(2)|浏览(144)

I got a SQL Server database which I would like to dump, but only indexes and maybe structure, but I couldn't figure it out how.

I use SQL Server Management Studio, but I cant see how would I do this. MySQL is much more easier then this :)

Any tips or how-to's would help.

NOTE: I'm new to SQL Server.

2条答案

To export the indexes, together with the table schemas, do these steps:

Click OK, complete the wizard, and you should now see the table schema SQL together with the indexes.

Right click database ->click on generate scripts --->Choose Script Entire database

In new window,click on Advanced and choose types of data to script as Schema only ..you can play with another options

now complete all the screens and you can see structure of all tables and indexes..