SELECT ‘IF EXISTS(SELECT 1 FROM sys.objects WHERE name = ”vw’ + t.name + ”’ AND type = ”V”) BEGIN DROP VIEW [v_’ + t.name + ‘] END CREATE VIEW [vw’ + t.name + N] AS SELECT ‘ + STUFF( (SELECT N’,[‘ + c.name+’]’ FROM sys.columns AS c WHERE c.OBJECT_ID = t.OBJECT_ID ORDER BY column_id FOR […]
Read more