1.User-Defined Functions: User-Defined Functions (UDFs) -- one or more Transact-SQL statements can be used to encapsulate code for reuse. Userdefined functions cannot make a permanent changes to the data or modify database tables. UDF can change only local objects for a UDF, such as local cursors or variables.
7. CASCADE :-CASCADE specifies that all the rows with foreign keys pointing to the deleted/updated row are also deleted/updated.