Diff in dropping a table || truncating a table || deleting all records

Dropping : (Table structure + Data are deleted), Invalidates the dependent objects ,Drops the indexes

Truncating: (Data alone deleted), Performs an automatic commit, Faster than delete

Delete : (Data alone deleted), Doesn’t perform automatic commit

Coders: DBMS/RDBMS

Coders: DBMS/RDBMS

Coders: POSTGRESQL vs MYSQL

Coders: POSTGRESQL vs MYSQL

Coders: DML DDL DCL TCL

Coders: DML DDL DCL TCL

Coders: Difference between Cluster and Non-cluster index

Coders: Difference between Cluster and Non-cluster index

Coders: UNIQUE constraints Vs UNIQUE index

Coders: UNIQUE constraints Vs UNIQUE index: "UNIQUE constraints Vs UNIQUE index"

Diff Between Function and Stored Procedure

A FUNCTION is always returns a value using the return statement.
A PROCEDURE may return one or more values through parameters or may not return at all.

A Function can be used in the Sql Queries.
A PROCEDURE cannot be used