| |
|
What is a database? Write the SQL syntax to create a database
A database is a repository of data, the collectively comprises of tables that are used to hold
data, views that fetch data from tables, stored procedures, triggers, functionsetc.
A database may comprise a single or multiple tables. An SQL server may comprise of
multiple databases, of course this also depends on the SQL Server software being used.
Further, a database may comprise of a single or multiple tables.
The relationships between different tables in a database are often referred to as Database Schema.
Say we have a database called 'db_Employees', in order to query this database, the following
syntax may be used in MS SQL:
use db_Emloyees -- This syntax is used in order to use this DB.
The question that comes to mind is, how is the above database created?
See the syntax below:
create database db_Employees --Syntax to create a database
SQL Queries
SQL
Create Table
DDL, Create, Alter, Drop commands
DML, Select, Insert, Update, Delete
Create Database
ACID Rules
Dual Table
NULL
Join, Inner, Outer, Left, Right, Full, Cartesian, Natural, Equi
Table, View and a Synonym?
Execute
Function
Stored Procedure
Syntax Stored Proc
Stored Procedure Vs. Function
| |