Databases: Creating and Removing
Learn how to create and remove databases in SQL Server.
We'll cover the following...
A database is a fundamental entity in MS SQL.
Most people think of a database as a collection of tables that hold user data. However, that is not the case with MS SQL database. It is better to think of it as a repository of database objects. Some examples of such objects are:
- Table: A place where the data is stored.
- View: This can be thought of as a virtual table.
- Stored procedure: A set of SQL statements that perform some action and can be reused any number of times. May or may not return a value.
- Function: These are the same