SQL DATABASE TUTORIAL

SQL SERVER

Posted by indranil on Jan. 31, 2021, 2:16 p.m.

SQL SERVER TUTORIAL

Create Database

Create Database Test;

use Test;

Create Table

create table TestTable(id int, student_name varchar(50), roll_no int, class varchar(50))

Delete Table

drop table TestTable;

Show Table Objects

select * from TestTable;

Filter Show Table Objects

select * from TestTable where id=1;

Insert Data In Table

create table TestTable(id int unique not null, student_name varchar(50), roll_no int, class varchar(50))

Delete Data In Table

delete from TestTable where id=3;

Delete All Data In Table

truncate table TestTable;

noimg Visit Link: digitalocean.com