DROP TABLE :-DROP TABLE table_nameDROP DATABASE :-DROP DATABASE database_nameTRUNCATE TABLE :-We use truncate statement if we want to delete the values of the table not the table itself. Like :-TRUNCATE TABLE table_nameDROP INDEX :-DROP INDEX table_name.index...
SQL Tools(Check , DEFAULT, CREATE INDEX)
Check :-CREATE TABLE SHIP_Orders( @O_ID INT NOT NULL, @ORDER_NAME VARCHAR(25), @ORDER_ADDRESS VARCHAR(45), CHECK(@O_ID>2))DEFAULT :-We can provide default values to the table like in the above table :-CREATE TABLE SHIP_ORDERS( @O_ID INT NOT NULL, @ORDER_NAME VARCHAR(25) DEFAULT 'SLITTING', @ORDER_ADDRESS VARCHAR(45)...
SQL Tools(Create DB, Create Table, UNION, UNION ALL, NOT NULL, UNIQUE, PRIMARY KEY, Foreign Key)
To Create Database :-CREATE DATABASE Db_NameTo Create Table :-CREATE TABLE Person( @ID INT NOT NULL, @Name VARCHAR(20), @ADDRESS VARCHAR(255) NOT NULL, @PS_NO SMALLINT, @FIRST_CHAR CHAR)if a column contains NOT NULL values then it means it does not allow the null values.Unique :- CREATE TABLE Person( @ID ...
SQL Tools( Count, MAX, MIN)
COUNT is a method which will count the total no of columns,total no of rows,total no of values.Like :-SELECT COUNT(Column_Name) FROM Table_NameThis will count total no of rows where First_Name is Saurabh.SELECT Count(*) FROM Table_Name WHERE First_Name = 'Saurabh'SELECT COUNT(First_Name) AS NoOfStudents FROM STUDENTSSTUDENTS is a Table_NameMax :-SELECT...
SQL Tools(SELECT INTO, INSERT INTO)
SQL SELECT INTO statement is used to select data from a SQL database table and to insert it to a different table at the same time.The general SQL SELECT INTO syntax looks like this:SELECT Column1, Column2, Column3, INTO Table2 FROM Table1This will create a Table2 same as Table1. SQL INSERT INTO :-1:- INSERT INTO Table1 VALUES (value1, value2, value3…)2:-...
Posts
