Generate Tables Script using SqlPubWiz.exe

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Generate Tables Script using SqlPubWiz.exe

Author

Topic

SQLSeeker
Starting Member

15 Posts

Posted - 2009-12-10 : 09:15:44

Hi,

I want to create database script of tables only. I tried by using SqlPubWiz.exe, but it generate script for all objects of database. Actually I want script of tables only. This exe gives schema only by giving argument as -schemaonly. Is there any argument by which I will get schema of tables only.

Thanks,

Vinnie881
Master Smack Fu Yak Hacker

1231 Posts

Posted - 2009-12-10 : 15:19:20

If you have SSMS

Right click on the DB then select Tasks ->Generate Scripts

Then uncheck Script ALL OBJECTS in database, and go throught the wizard. Once you get to the part where you can select object types just select tables.

Success is 10% Intelligence, 70% Determination, and 22% Stupidity.
\_/ _/ _/\_/ _/\_/ _/ _/- 881

SQLSeeker
Starting Member

15 Posts

Posted - 2009-12-10 : 23:12:11

Hi,
Thanks for your reply. Actually i want to automate that wizard to generate schema of tables only.

Thanks,

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources