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!