Create view in SQL through linked server to Teradata

Database

Create view in SQL through linked server to Teradata

Hi,

I'm trying to create a view in SQL Server 2005 from a Teradata table through linked server, simply like this:

create view [dbo].[ePolicy] as select * from openquery(db_prod,'select * from tbl_policy')

The view is created successfully. But when I check the view definition it is showing the column title from Teradata table instead of the column name.

Could anyone help me how to get the column name? I have over a hundred columns in the table. It would be painful if I have to add the alia name for each column.

Thanks a lot!

Amy