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 – Date Functions The Date & time functions are built-in functions in the SQL server that allows you to manipulate and perform operations on date and time values in the SQL server. These functions can be used in SQL Server queries to perform various date and time operations, such as filtering records based on […]
SQL – String Functions SQL string functions are used primarily for string manipulation. The following table details the important string functions − Sr.No. Function & Description 1 Returns numeric value of left-most character 2 Returns the character for each integer passed 3 Returns the position of a substring within the given string. 4 Returns concatenate […]