Search
 
SCRIPT & CODE EXAMPLE
 

SQL

truncate statement in sql

/*truncate table syntax*/
/*table name is Employees*/
TRUNCATE TABLE Employees;
Comment

Truncate Table in SQL

TRUNCATE TABLE Customers;
Comment

what is truncate in sql

DELETE -
-DML COMMAND
-Delete Rows from the table one by one
-We can use where clause with Delete to delete single row
-Delete is slower than truncate
-ROLLBACK is possible with DELETE

DROP-
-DDL COMMAND
-Delete the entire structure or schema
-We can't use where clause with drop
-Drop is slower than DELETE & TRUNCATE
-ROLLBACK IS NOT POSSIBLE WITH DROP

TRUNCATE-
-DDL COMMAND
-Truncate deletes rows at a one goal
-We can't use where clause with Truncate
-Truncate faster than both DELETE & DROP
-Rollback is not possible with Truncate
Comment

truncate syntax in sql

+----+----------+-----+-----------+----------+
| ID | NAME     | AGE | ADDRESS   | SALARY   |
+----+----------+-----+-----------+----------+
|  1 | Ramesh   |  32 | Ahmedabad |  2000.00 |
|  2 | Khilan   |  25 | Delhi     |  1500.00 |
|  3 | kaushik  |  23 | Kota      |  2000.00 |
|  4 | Chaitali |  25 | Mumbai    |  6500.00 |
|  5 | Hardik   |  27 | Bhopal    |  8500.00 |
|  6 | Komal    |  22 | MP        |  4500.00 |
|  7 | Muffy    |  24 | Indore    | 10000.00 |
+----+----------+-----+-----------+----------+
Comment

sql truncate number

-- Truncate number with cast
UPDATE my_table
SET my_column = CAST(my_column AS INT)
WHERE ...;
-- or convert
UPDATE my_table
SET my_column = CONVERT(INT, my_column)
WHERE ...;
Comment

PREVIOUS NEXT
Code Example
Sql :: insert data into multiple tables mysql 
Sql :: how to check common records in 2 table 
Sql :: querry mysql by 2 columns 
Sql :: if role exists sql 
Sql :: python sqlalchemy orm to select null values 
Sql :: round border button tkinter 
Sql :: tsql find procedure with name 
Sql :: postgres between dates 
Sql :: oracle for loop on list 
Sql :: insufficient privileges while creating view in sql oracle 
Sql :: Write an SQL query to fetch the count of employees working in the department ‘Admin’. 
Sql :: do block in postgresql 
Sql :: update from select postgresql 
Sql :: sql insert into select statement 
Sql :: check constraint in ms sql 
Sql :: keys in sql with example 
Sql :: mysql dump structure only 
Sql :: Create parameterized VIEW in SQL Server 
Sql :: denormalization in sql example 
Sql :: postgres create trigger if not exists 
Sql :: mysql set column equal to another automatic 
Sql :: mysql preg replace 
Sql :: sql cross apply vs join 
Sql :: order by postgres 
Sql :: was not locked with LOCK TABLES 
Sql :: if exist column in table drop sql query mysql 
Sql :: mysql null 
Sql :: mysql with docker 
Sql :: sql insert all 
Sql :: rename command in sql 
ADD CONTENT
Topic
Content
Source link
Name
7+1 =