What is a view?
A view is a virtual table based on the result set of an SQL statement.
Here is an example.
create view [sales].[v.salesbyperson2] as select salespersonid, round(totaldue,2) as salesamount from sales.sales
What is a synonym?
A synonym, like the name, is an alternate name we create for another database object.
Here is the syntax:
create synonym [synonym_name] for [server_name].[database_name].[schema_name].[object_name]
What is the trigger?
A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server.
Regardless of whether or not any table rows are affected.
Here is an example:
create trigger reminder1 on sales.customer after insert, update as raiserror ('notify customer relations', 16, 10); go
If you are interested in or have any problems with SQL or Business Intelligence, feel free to contact me.
Or you can connect with me through my LinkedIn.