In this tutorial, we will show you how to Drop or delete a database in SQL Server is using the Drop Database statement and also using SQL Server Management Studio.
In this tutorial, we will show you how to create a database in SQL Server. There are two ways by which you can create a database in SQL Server. One is using the GUI Tools of the Management Studio. The other option is to use the SQL Query.
A SQL Server Database is an organized collection of data and supporting data structure & tools to manage it. The data is stored in a series of tables. A database does not only contain the data but also contains
This Article lists the Reserved Keywords in SQL Server. The identifiers we give to the database objects like column names and table names etc should not use these words. If you want to use them, then you should always use the Delimited format by enclosing them in square brackets  or double quotation marks (“”)
Identifiers are the name we give to the Servers, Databases, and Database objects, such as Tables, Views, Columns, Indexes, Triggers, Procedures, Constraints, and Rules, etc. They must uniquely identify them. We then use the identifier to refer to the server, database, table whenever we want to use them. There are certain rules & restrictions that we must follow when we choose the name for the identifier.