Create Database:
CREATE DATABASE MyDataBaseName
Query:
CREATE DATABASE Information
Database called Information will be created
Create Table:
Table exists with in data base, so it is important to mention with in which data base you want table to be created
Query:
USE [Information]
CREATE TABLE Persons
(
P_Id int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)
Table called Persons will be created under data base Information
Column of the table will be, P_id, LastName, FirstName, Address, City.
Data Type is int, varchar, date etc.
SQL Constraints:
Constraints are used to limit the type of data that can go into a table. In the above picture you can be Column name P_Id and (int, null), null means, P_id column can have null value. If you create a table with query below, P_Id and LastName Columns can not have null value.
Query:
CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)
NOT NULL constraints means value for that column can not be NULL. In the above example P_id and LastName can not be left null.
I deleted the table Persons created and created the same table with new query. Only difference between table created before and now is IP_Id and LastName constraint is not null.
No comments:
Post a Comment