The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. It is also used to add and remove various
Category: SQL Server
ALTER DATABASE in SQL Server
This article will go over various ALTER DATABASE statements in SQL Server. This aids in changing the database name, properties, files, recovery methods, file locations,
TRUNCATE TABLE in SQL
TRUNCATE TABLE is a Data Definition Language operation in SQL that marks the extent of a table for deallocation. This operation removes all data from
Naming Conventions in SQL
Why is a naming convention required in SQL? The short answer is READABILITY. A naming convention is a set of rules that you decide on
Aliases in SQL
In this post, we’ll go over aliases in SQL Server. The following are some key points about Aliases. In SQL Server, aliases can be used
Disable and Enable Index in SQL Server
This topic describes how to disable and enable an index in SQL Server. Disabling an index prevents users from accessing the index and, in the
Big Data & SQL 