SCHEMABINDING

GO
CREATE VIEW vAllArtist AS
    SELECT * FROM artist;
GO
SELECT * FROM vAllArtist;

-- drop view vAllArtist;

GO
CREATE VIEW vAllArtistWithAlbums AS
    SELECT art.creation_date "creationDate", art.name as "Artysta", alb.title as "Nazwa_albumu", gen.name as "Gatunek", 
    alb.year as "Rok_wydania" FROM dbo.artist art INNER JOIN dbo.album alb ON artist_artist_id = artist_id
    INNER JOIN dbo.genre gen ON genre_genre_id = genre_id ;
Go
SELECT * FROM vAllArtistWithAlbums ORDER BY vAllArtistWithAlbums.[Artysta], vAllArtistWithAlbums.[Nazwa_albumu];


GO
CREATE VIEW vAlbums WITH SCHEMABINDING AS
    SELECT a.album_id, a.title, a.track_no, a.year from dbo.album a;
GO
SELECT * FROM vAlbums;
Go
CREATE UNIQUE CLUSTERED INDEX IDX_vAllAlbums ON vAlbums(album_id);
GO
SELECT * FROM vAlbums;
GO

CREATE VIEW vAllConcerts WITH SCHEMABINDING AS
    SELECT c.concert_id, c.venue, c.[Date], art.name as "Artist" from dbo.concerts c JOIN dbo.artist art ON Artist_Artist_id = artist_id;
GO
SELECT * FROM vAllConcerts;
GO
CREATE UNIQUE CLUSTERED INDEX IDX_vAllConcerts ON vAllConcerts(concert_id);
GO
SELECT * FROM vAllConcerts;

GO
CREATE VIEW vFavourite WITH SCHEMABINDING AS
    SELECT rel.release_id, alb.title FROM dbo.release rel JOIN dbo.album alb ON album_album_id = album_id WHERE rel.isfavourite = 1;
GO
SELECT title FROM vFavourite;
GO
CREATE UNIQUE CLUSTERED INDEX IDX_vFavourtireAlbums ON vFavourite(release_id);
GO
SELECT title FROM vFavourite;