Skip to main content

SQL Server tutorial part 2 - DDL (Data Definition Language) - Create Table

The CREATE TABLE statement is used to create a new table in a database. The following constraint can be applied when creating a table:
  • NOT NULL - Ensures that a column cannot have a NULL value
  • UNIQUE - Ensures that all values in a column are different
  • PRIMARY KEY - A combination of a NOT NULL and UNIQUE. Uniquely identifies each row in a table
  • FOREIGN KEY - Uniquely identifies a row/record in another table
  • CHECK - Ensures that all values in a column satisfy a specific condition
  • DEFAULT - Sets a default value for a column when no value is specified
  • INDEX - Used to create and retrieve data from the database very quickly


Using script


Create temporary table




Using GUI

In SQL server management studio expand the database created and right click on "TABLES" from the context menu select NEW > TABLE


Create your table and right click on the column that you want to make it as a primary key constraint and from the context menu select Set Primary Key




In the Column property panel, search for "Identity Specification" expand it and change option "Is Identity" from no to yes



Use Ctrl + S on your keyboard to save the table or click the save icon

Please donate and support at https://www.paypal.me/Rajcoomar

Labels:

Comments

Post a Comment

Popular posts from this blog

Car Wash System vb.net

This software consists of a database that save the registration number of every vehicle being wash along side with the date, type of wash made and price Screen Shot Source Code To view records in the database: Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\washRcd.accdb;Persist Security Info=False") Dim sql As String sql = " SELECT * FROM tblwash" conn.Open() Dim dt As New DataTable Dim cmd2 As New OleDb.OleDbDataAdapter(sql, conn) cmd2.Fill(dt) DataGridView1.DataSource = dt DataGridView1.Refresh() conn.Close() To insert new record in the database: Private Sub insert() Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\washRcd.accdb;Persist Security Info=False") Dim updateSql As String = String.Format(...
10 comments
Read more

C# Windows Form : PetCare

A desktop application using C# as technology. the application is titled as "PETCARE" a system that a pet shop or veterinary can use it to store basic information about the pet's owner, details about the pet and the purpose of the visit to the veterinary or pet shot. The system also contained a stock management module that is used to track pet food purchased by a particular customer Screen Shot You can login both as a staff or as the admin. the admin has the privilege to register new staff and view details about transaction and other sensitive information. The system encrypt user password using MD5 algorithm The home screen of the application You can either add a new pet with its owner details or add another pet belonging to the same owner. both can be done using the same form below. and each pet owner will be given a reference number. Veterinary can use the application to store information about treatment done for a particular pet Can t...
1 comment
Read more

Student Information System - AngularJS , ASP.NET API, C#

Web based application the student information system is a small application that allows user to register and login to view information about a particular student and can perform several actions like Login and register to the application View students  Add new student Delete a particular student Update user information Screen Shot Project architecture routing.js, config.js and app.js allow the application to route from one partial view to another and config.js is used to save all the endpoint needed to access the API.   For separation of concerns, in the solution panel separate partial views, controller and services in different directories and reference it in index.html to enable angular to load all the files required Login process login.html LoginController.js Using $resource from AngularJS to make an API call and response  with a user details model UserViewModel and UserDetailsViewModel Using Unity fo...
2 comments
Read more