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 ...
Posts
