Sql

//to delete complete table and data
drop table 'table name'

//to clear only data in a table and keep table structure
truncate table 'table name'

PREVIOUS	NEXT

Code Example
Sql :: sql decimal to 2 places
Sql :: how select a json value in mysql
Sql :: clone table structure mysql
Sql :: enable service broker in sql server
Sql :: blob datatype in mysql
Sql :: nosql databases list
Sql :: vacuum table postgres
Sql :: mysql list users
Sql :: ubuntu reset mysql root password
Sql :: mysql current date
Sql :: insert data from another table
Sql :: sql check double value
Sql :: sql truncate statement
Sql :: delete temp table if exists
Sql :: sql where first letter
Sql :: how to see the query of a view in mysql
Sql :: oracle replace
Sql :: sql count group by
Sql :: sql server select value large text
Sql :: drop view sql
Sql :: oracle insert or update
Sql :: oracle convert int to date
Sql :: how to truncate table with foreign key constraint postgresql
Sql :: DROP TABLes regardless of constraints
Sql :: create table in sql
Sql :: postgresql distinct
Sql :: check if string contains substring sql
Sql :: sqlite show table indexes
Sql :: sql convert date to string yyyy-mm-dd
Sql :: read all columns of a table sql