Posted by clir on 03/12/07 11:44

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: Re: get value of last item in column?
• Prev in forum: Re: get value of last item in column?
• Thread view: CREATE VIEW - script to automate column names?

[Reply to this message]