Cacher is the code snippet organizer for pro developers

CREATE TABLE Mushrooms (
    edible_poisonous		  [varchar](15) NULL,
    cap_shape				   [varchar](15) NULL,
    cap_surface			   [varchar](15) NULL,
    cap_color				   [varchar](15) NULL,
    bruises				   [varchar](15) NULL,
    odor					   [varchar](15) NULL,
    gill_attachment			   [varchar](15) NULL,
    gill_spacing			   [varchar](15) NULL,
    gill_size				   [varchar](15) NULL,
    gill_color				  [varchar](15) NULL,
    stalk_shape			   [varchar](15) NULL,
    stalk_root				  [varchar](15) NULL,
    stalk_surface_above_ring	   [varchar](15) NULL,
    stalk_surface_below_ring	   [varchar](15) NULL,
    stalk_color_above_ring	   [varchar](15) NULL,
    stalk_color_below_ring	   [varchar](15) NULL,
    veil_type				   [varchar](15) NULL,
    veil_color				  [varchar](15) NULL,
    ring_number			   [varchar](15) NULL,
    ring_type				   [varchar](15) NULL,
    spore_print_color		   [varchar](15) NULL,
    population				  [varchar](15) NULL,
    habitat				   [varchar](15) NULL
)






BULK INSERT Mushrooms  
FROM 'Z:\SolidQ\Formazione\Data Science\DataScience Slide\Demo_01\agaricus-lepiota-na-expanded.csv'  
WITH  
    (  
	FIRSTROW = 2,
    FIELDTERMINATOR =',',  
    ROWTERMINATOR = '\n',
	KEEPNULLS
    ); 


CREATE SCHEMA dm;
GO

CREATE VIEW dm.vw_Mushrooms AS 
SELECT
  Id = ROW_NUMBER() OVER (ORDER BY cap_shape)
, M.edible_poisonous
, M.cap_shape
, M.cap_surface
, M.cap_color
, M.bruises
, M.odor
, M.gill_attachment
, M.gill_spacing
, M.gill_size
, M.gill_color
, M.stalk_shape
, M.stalk_root
, M.stalk_surface_above_ring
, M.stalk_surface_below_ring
, M.stalk_color_above_ring
, M.stalk_color_below_ring
, M.veil_type
, M.veil_color
, M.ring_number
, M.ring_type
, M.spore_print_color
, M.population
, M.habitat
FROM dbo.Mushrooms AS M