Defining & Creating views

[neil]

Hi,

Is it possible to define a column when creating a view.

I knowyou can determine the name of the column..but is there a way to determine
content like when creating a table...

i.e as in creating a table

create tabe table1
(column1 char(10));

Is this possible with creating views...

Any help would be grateful cheers

[JC]

Hi!

nope, i don't think what you wanted could be done. but you could try something
like this and it will generate the same result :

Create View Pubs [Pub_name] <--- (optional)
As
Select cast(pub_name as Char(10))
From Publishers
Go


hope this helps!

JC


"neil" <neil.ward@document.co.uk> wrote:
>
>Hi,
>
>Is it possible to define a column when creating a view.
>
>I knowyou can determine the name of the column..but is there a way to determine
>content like when creating a table...
>
>i.e as in creating a table
>
>create tabe table1
>(column1 char(10));
>
>Is this possible with creating views...
>
>Any help would be grateful cheers

[neil]

Cheers JC..this works a treat..many thanks

Neil



"JC" <jcarlosra@digitelone.com> wrote:
>
>Hi!
>
>nope, i don't think what you wanted could be done. but you could try something
>like this and it will generate the same result :
>
> Create View Pubs [Pub_name] <--- (optional)
> As
> Select cast(pub_name as Char(10))
> From Publishers
> Go
>
>
>hope this helps!


>
>JC
>
>
>"neil" <neil.ward@document.co.uk> wrote:
>>
>>Hi,
>>
>>Is it possible to define a column when creating a view.
>>
>>I knowyou can determine the name of the column..but is there a way to determine
>>content like when creating a table...
>>
>>i.e as in creating a table
>>
>>create tabe table1
>>(column1 char(10));
>>
>>Is this possible with creating views...
>>
>>Any help would be grateful cheers
>