Find out a particular column throughout the database in Postgresql
Previously got a situation where I needed to get tby Nitika.Verma
Truncate and drop both are similar to each other as they are used to delete the complete data of a table. The difference between them is this truncate only delete the data of the table where as the table structure is there but when we drop the...
SQL Truncate Table Using this statement you can remove all data of rows or column ( complete data ) not table. In this there is no where clause but where clause is available in Delete statement. Truncate table is faster than Delete statement ...