SQL – DROP Database Table of content The SQL DROP DATABASE statement is used to delete an existing database along with all the data such as tables, views, indexes, stored procedures, and constraints. SQL DROP Database Statement Following are the important points to remember before you delete an existing database − Make sure you have […]
Category Archives: sql
SQL – Logical Functions SQL logical functions are used primarily for checking (or testing) the truth of some conditions. A logical function performs a logical operation or comparison on objects and expressions and returns a boolean value − Sr.No. Function & Description 1 Returns a item from the list at the specified index value. 2 […]
SQL – Statistical Functions SQL server Statistical functions work on SQL server tables and views and exploit all database parallelism, scalability, user privileges and security schemes. Hence the SQL statistical functions can be included and exposed within SQL queries − Sr.No. Function & Description 1 Returns number of attempted connections. 2 Returns amount of time, […]