Author Archives: user

SQL – Clone Tables Table of content There may be a situation when you need an exact copy of a table with the same columns, attributes, indexes, default values and so forth. Instead of spending time on creating the exact same version of an existing table, you can create a clone of the existing table. […]

SQL – TRUNCATE TABLE Table of content SQL provides command to TRUNCATE a table completely in one go instead of deleting table records one by one which will be very time consuming and cumbersome process. The SQL TRUNCATE TABLE Statement The SQL TRUNCATE TABLE command is used to empty a table. This command is a […]

SQL – Rename Database Table of content There can be several reasons to rename a database name. One of the reasons could be to avoid naming conflicts or to separate different types of data into different databases. Another reason can be to arrange them in an organized way which makes them more descriptive and easier […]