Get database build script via sql code

[hmckillop]

Hello

i dont have access to my SQL database only access to asp pages. So I planned to run a script on one of the asp pages which would show an actual database build script (note the db only currently contains tables - with possible indexes) which I would then paste into QA and then run locally - thus allowing me to rebuild the database schema locally.
Any quick suggestions - i have a way of doing it but it seems it will take a while and just wanted to see if there was a shorter way.
Thanks in advance

"I'm living so far beyond my income that we may almost be said to be living apart

 

[mrdenny]

You would have to use the INFORMATION_SCHEMA views to get the information.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[hmckillop]

I had been using the system tables which I suppose is the same data as information_schema. I just thought maybe there was a "magic" stored proc which would create build scripts but after running profiler whilst scripting another database I see that doesnt happen.
Thanks for reply though.

Cheers


"I'm living so far beyond my income that we may almost be said to be living apart

 

[hmckillop]

found what I am looking for here -

http://www.databasejournal.com/features/mssql/article.php/3401081

Allows the scripting of a database with use of Microsofts scptxfr.exe which is packaged with SQL Server.
Just in case you wanted to know.

"I'm living so far beyond my income that we may almost be said to be living apart