Drop Temp Table in SQL Server and PostgreSQL

Database development, Statements, Tables

This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the...
Read More

Guide for CTE in SQL Server

Database development, Tables

The Common Table Expression aka CTE in SQL Server provides a temporary result set in T-SQL. You can refer to it within a SQL Select, SQL...
Read More

How to SHOW or LIST Tables in MySQL

Database development, Tables

There are two primary methods to view the tables in MySQL: The MYSQL SHOW TABLES command. Querying the Information_schema.tables table. In...
Read More

Stored Procedure to Delete Duplicate Records in SQL Table

Database development, Stored Procedures, Tables

Sometimes during our run as DBAs, we come up across at least one table that is loaded with...
Read More

How to Create a Table with Multiple Foreign Keys and Not Get Confused

Constraints, Database development, Tables

Understanding Table Relations SQL server adds foreign keys to implement relations between tables in a relational database. A table can have...
Read More

The Cartesian Product in SQL

Database development, Tables

Cartesian product in SQL is a term from the set theory of mathematics. However, we can also find this term in SQL database manuals. What...
Read More

SQL DEFAULT Constraint to Insert Column with a Default Value to SQL Server Table

Database development, Tables

To insert data into a table having columns with default constraints, we can use the DEFAULT...
Read More

3 Methods to Rebuild All Indexes for All Tables with T-SQL in SQL Server Database

Database development, Indexes, Languages & Coding, T-SQL, Tables

There are several methods of how to rebuild all indexes of all tables in SQL Server, among them: Using SQL Server maintenance plans. Using...
Read More

4 Ways to Count Rows in SQL Server Table with Pros and Cons

Database development, Statements, Tables

Recently, I was working on a database performance improvement project. One stored procedure there was causing issues. In its code, a query...
Read More

Understanding DROP TABLE Statement in SQL Server

Database development, Statements, Tables

The SQL Server DROP TABLE statement serves to drop the table from the database. This article will...
Read More
Close