About Lesson
/*
Unique and Non-Unique Indexes
Unique index is used to assure uniqueness of key values in the index
So. Primary Key of a table always be UNIQUE CLUSTERED INDEX
we can check with sp_helpindex tblEmp
to create unique index just prefix unique word with your index (clustered or nonclustered )
Create Unique NonClustered Index index_name On tableName(col1, colo2,…) View is a virtual table of a select query
create view viewname
as
select query;
*/