Dynamic SQL to create 300 Views from our Tables

Bobby P 231

We have a requirement to create over 300 VIEWs from our Database Tables. Straight SELECT * from the Table.

I was planning on doing this using Dynamic SQL but I know I will exceed the implied space limit on the dynamically built SQL Variable.

Does anyone have a suggestion as to how to approach this?

I think I saw in my travels that using OPENQUERY may be an option. But I know I will have to create a script in our environment for SDLC purposes.

Thanks in advance for your review and am hopeful for a reply.

Erland Sommarskog 122.7K Reputation points MVP Volunteer Moderator

2023-05-19T21:43:38.8833333+00:00

I was planning on doing this using Dynamic SQL but I know I will exceed the implied space limit on the dynamically built SQL Variable.

You are not reading the response to your questions, are you? I pointed out in a reply to one of your other questions that there is no practical limit. (It's 2GB.)
LiHongMSFT-4306 31,576 Reputation points

2023-05-22T02:59:09.97+00:00

Hi @Bobby P

Did you have a chance to try the answer below?

And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

Thanks for your understanding!

1 answer

Jingyang Li 5,896 Reputation points Volunteer Moderator

2023-05-19T16:18:47.19+00:00

Check out this:

https://stackoverflow.com/questions/23166423/how%E2%80%93to%E2%80%93create%E2%80%93view%E2%80%93for%E2%80%93all%E2%80%93tables%E2%80%93in%E2%80%93database
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer