Category Archives: sql

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 […]

SQL – Datatype Functions The Data Type functions in SQL are a scalar functions that returns information about various data type values. Following are the SQL date type functions − Sr.No. Function & Description 1 Returns the number of bytes used to represent any expression and also counts the leading and trailing spaces of the […]

SQL – Useful Functions SQL has many built-in functions for performing processing on string or numeric data. Following is the list of all useful SQL built-in functions − – The SQL COUNT aggregate function is used to count the number of rows in a database table. – The SQL AVG aggregate function selects the average […]