SQL Server Tables

SQL Server Drop Table only if exists

How to, with SQL Server Drop Table only if exists? How to drop it only if it already exists in the database to avoid errors, use the DROP keyword. Indeed when running long SQL scripts or running scripts twice, it is much better to test the table existence. Indeed, we highly

SQL Server Tables

SQL Server Alter Table

How to modify an object with an SQL Server Alter Table query? This ALTER TABLE SQL Server query helps you modify an already existing table. This SQL script allows you to modify the Sales table previously created, by changing the length of the Month Name column. Of course you need

SQL Server Tables

SQL Server Create Table

How to build an SQL Server Create Table query? This basic example creates a Sales table. It is using different data types, such as strings, numeric values, decimal values, integers and Boolean.   This SQL Server example is easy to customize. Just copy and paste it to your computer, inside your