http://blog.sqlauthority.com/2009/06/17/sql-server-list-schema-name-an

home
database
view story

8 Kicks

http://blog.sqlauthority.com/2009/06/17/sql-server-list-schema-name-an(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 11 months ago

Just a day ago, I was looking for script which generates all the tables in database along with its schema name. I tried to Search@SQLAuthority.com but got too many results. For the same reason, I am going to write down today’s quick and small blog post and I will remember that I had written I wrote it after my 1000th article.

3 comments |category: Database |Views: 145
Tweet

tags: SQLAuthority pinaldave SQLServer Database SQL another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

subhashpunia(35) -

alashcraft(1180) -

mdopp(856) -

codebetter(0)

More who kicked this story...

Comments:

posted by softomic(0) 2 years, 11 months ago 0

pinaldave,

If you have access to SQL Server Management Studio, you can easily do it with the script wizard. Right click on your database, choose tasks >> generate scripts from the popout menu. That opens a wizard which allows you to generate sql scripts to create the whole database or any parts. You can send the results to a file or clipboard or the window. I bet you can write an SSIS job to do this on the fly if you do this task on the fly.

Paul

posted by JudahGabriel(814) 2 years, 11 months ago 0

Ummm, how about a meaningful title, rather than a URL?

posted by pinaldave(9662) 2 years, 11 months ago 0

The title was mistake. As I did not have edit facility I could not edit it.

Hope you have liked the story.

Kind Regards,
Pinal

Most Active Users

What's this?