USE AdventureWorks;

DECLARE @schema sysname, @table sysname;

SELECT @schema = N'Production', @table = N'Product';

SELECT 1 AS ordr, N'CREATE VIEW ' + QUOTENAME(@schema) + N'.' + QUOTENAME(N'view_' + @table) + N' AS SELECT' AS string
UNION ALL
SELECT c.ORDINAL_POSITION + 1, CASE WHEN c.ORDINAL_POSITION = 1 THEN N'' ELSE N',' END +
       CASE
           WHEN c.DATA_TYPE IN (N'nchar', N'nvarchar')
           THEN N'CONVERT(' + STUFF(c.DATA_TYPE, 1, 1, N'') + N'(' + CONVERT(nvarchar(30), c.CHARACTER_MAXIMUM_LENGTH) + N'), ' + QUOTENAME(c.COLUMN_NAME) + N') AS '
           ELSE N''
       END +
       QUOTENAME(c.COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS c
WHERE c.TABLE_SCHEMA = @schema AND c.TABLE_NAME = @table
UNION ALL
SELECT 100000, N'FROM ' + QUOTENAME(@schema) + N'.' + QUOTENAME(@table)
ORDER BY ordr;

CREATE VIEW [Production].[view_Product] AS SELECT
   [ProductID]
  ,CONVERT(varchar(50), [Name]) AS [Name]
  ,CONVERT(varchar(25), [ProductNumber]) AS [ProductNumber]
  ,[MakeFlag]
  ,[FinishedGoodsFlag]
  ,CONVERT(varchar(15), [Color]) AS [Color]
  ,[SafetyStockLevel]
  ,[ReorderPoint]
  ,[StandardCost]
  ,[ListPrice]
  ,CONVERT(varchar(5), [Size]) AS [Size]
  ,CONVERT(char(3), [SizeUnitMeasureCode]) AS [SizeUnitMeasureCode]
  ,CONVERT(char(3), [WeightUnitMeasureCode]) AS [WeightUnitMeasureCode]
  ,[Weight]
  ,[DaysToManufacture]
  ,CONVERT(char(2), [ProductLine]) AS [ProductLine]
  ,CONVERT(char(2), [Class]) AS [Class]
  ,CONVERT(char(2), [Style]) AS [Style]
  ,[ProductSubcategoryID]
  ,[ProductModelID]
  ,[SellStartDate]
  ,[SellEndDate]
  ,[DiscontinuedDate]
  ,[rowguid]
  ,[ModifiedDate]
FROM [Production].[Product]

declare
 v_tbl varchar2(32):='EURUSD_TICKS' ;
 v_sql varchar2(2000);
begin
FOR FIELDS IN (select
                     (CASE c.DATA_TYPE WHEN 'NUMBER' THEN ' to_char('||c.COLUMN_NAME||') AS '||c.COLUMN_NAME ELSE c.COLUMN_NAME END) as fld  
                from user_tab_cols c where c.TABLE_NAME='EURUSD_TICKS' 
               order by c.COLUMN_ID) LOOP
 IF v_sql IS NULL THEN
 v_sql:=FIELDS.fld;
 ELSE
 v_sql:=v_sql||' ,'||FIELDS.fld;
 END IF;
END LOOP;
 dbms_output.put_line(v_sql);
 EXECUTE IMMEDIATE 'CREATE OR REPLACE VIEW V_'||v_tbl||' AS SELECT '||v_sql||' FROM '||v_tbl;
end;

declare 
@s varchar(2000),
@t varchar(1000),
@tableName varchar(1000)
select @tableName=N'T40000533'
SELECT @s=@s+','+CASE WHEN c.ORDINAL_POSITION = 1 THEN N'' ELSE N',' END + CASE
           WHEN c.DATA_TYPE IN ('nchar','nvarchar')
           THEN N'CONVERT(' + STUFF(c.DATA_TYPE, 1, 1, N'') + N'(' + CONVERT(nvarchar(30), c.CHARACTER_MAXIMUM_LENGTH) + N'), ' + QUOTENAME(c.COLUMN_NAME) + N') AS '
           ELSE N''
       END +
       QUOTENAME(c.COLUMN_NAME)
FROM [DWH\DWH].[CDW_DEMO_R26].INFORMATION_SCHEMA.COLUMNS c
WHERE c.TABLE_NAME = @tableName
ORDER BY c.ORDINAL_POSITION
select @s=substring(@s,2,len(@s)-1)
print(@s)
select @t=N'CREATE VIEW V_'+@tableName+N' as select '+@s+N' from [DWH\DWH].[CDW_DEMO_R26].[dbo].['+@tableName+']'
exec(@t)

CREATE VIEW V_T40000533 as select * from [DWH\DWH].[CDW_DEMO_R26].[dbo].[T40000533]

declare 
@s varchar(2000),
@t varchar(1000),
@tableName varchar(1000)
select @tableName=N'T40000533'
SELECT @s=@s+','+CASE WHEN c.ORDINAL_POSITION = 1 THEN N'' ELSE N',' END + CASE
           WHEN c.DATA_TYPE IN ('nchar','nvarchar')
           THEN N'CONVERT(' + STUFF(c.DATA_TYPE, 1, 1, N'') + N'(' + CONVERT(nvarchar(30), c.CHARACTER_MAXIMUM_LENGTH) + N'), ' + QUOTENAME(c.COLUMN_NAME) + N') AS '
           ELSE N''
       END +
       QUOTENAME(c.COLUMN_NAME)
FROM [DWH\DWH].[CDW_DEMO_R26].INFORMATION_SCHEMA.COLUMNS c
WHERE c.TABLE_NAME = @tableName
ORDER BY c.ORDINAL_POSITION
select @s=substring(@s,2,len(@s)-1)
print(@s)
select @t=N'CREATE VIEW V_'+@tableName+N' as select '+@s+N' from [DWH\DWH].[CDW_DEMO_R26].[dbo].['+@tableName+']'
exec(@t)

declare
@s varchar(200)
SELECT @s = @s + ','+ c.COLUMN_NAME FROM [DWH\DWH].[CDW_DEMO_R26].INFORMATION_SCHEMA.COLUMNS c WHERE c.TABLE_NAME = 'T40000533'
print ('-----------------------')
print (@s)
print ('-----------------------')

SELECT c.COLUMN_NAME FROM [DWH\DWH].[CDW_DEMO_R26].INFORMATION_SCHEMA.COLUMNS c WHERE c.TABLE_NAME = 'T40000533'

-----------------------

-----------------------