SQL Server Tables

SQL Server Drop Table only if exists

How to drop a SQL Server table only if exists? How to drop it only if the existence check shows it already exists in the database to avoid errors, using the DROP TABLE keyword. Indeed when running long SQL scripts or running scripts twice, it is much better to test

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