Posted by Tom van Stiphout on 03/14/07 02:43

On 12 Mar 2007 04:44:56 -0700, "clir" <christophe.leroquais@gmail.com>
wrote:

Use a cursor to loop over the column names, all the while
concatenating a string variable. In the end, execute that string
(sp_executesql) and your view will be created.

-Tom.



>Hi,
>
>I'm trying to create views on all my existing tables and for that I'd
>like to create a script or so.
>I don't want to specify the '*' for the columns in the create view
>statement. I prefer to specify the column names.
>I have the column names int sys.columns table but Do not know how to
>handle them to have a statement like that:
>
>CREATE VIEW myVIEW
>WITH SCHEMABINDING
>AS
> SELECT col1name, col2name, col3name, etc...
> from sys.columns
> ....?????.....
>
>
>Anyone can help?
>
>thx,
>
>Chris

• Next in forum: SQL Query help
• Prev in forum: Wishful thinking: SourceSafe integration with SQL Server
• Thread view: Re: CREATE VIEW - script to automate column names?

[Reply to this message]