ALTER COMMAND IN SQL || DDL COMMANDS || SQL COMMANDS || ALTER DATABASE || MYSQL || DBMS

ALTER COMMAND IN SQL

- DDL COMMAND

- To change the shcema / Structure of database

* Add Column
* Delete Column
* Modify datatype of existing column
* Set constraints like NOT NULL, PRIMARY KEY, UNIQUE KEY etc..
* Remove constraints
-----------------------------------------------------------------------------------

ADD COLUMN

alter table table_name
add column_name datatype

DROP COLUMN

alter table table_name
drop column column_name

MODIFY DATATYPE

alter table table_name
modify column column_name datatype

ADD NOT NULL

alter table table_name
modify column_name datatype NOT NULL

ADD CONSTRAINT UNIQUE

alter table table_name
add constraint unique(column_name)

ADD PRIMARY KEY CONSTRAINT

alter table table_name
add constraint primary key(column_name)

ADD CONSTRAINT CHECK

alter table table_name
add constraint check(condition)

DROP CONSTRAINT PRIMARY KEY

alter table table_name
drop primary key

DROP CONSTRAINT UNIQUE

alter table table_name
drop index column_name

----------------------------------------------------------------------------------------------------
HOW TO DOWNLOAD & INSTALL MySQL IN WINDOWS 10
   • HOW TO DOWNLOAD & INSTALL MySQL IN WI...  

DATABASE MANAGEMENT SYSTEM
   • DATABASE MANAGEMENT SYSTEM  

PYTHON PROGRAMS
   • PYTHON PROGRAMS  

C PROGRAMMING
   • 01 - VARIABLES & CONSTANTS in C PROGR...  

CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS
   • CORE JAVA TUTORIAL FOR BEGINNERS || L...  

HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS
   • HTML TUTORIALS WITH IMPLEMENTATION ||...  

LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS
   • LEARN CSS IN 3 HOURS || CASCADING STY...  

JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT
   • JAVA SCRIPT FOR BEGINNERS IN 7 HOURS ...  

PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో)
   • PYTHON TUTORIAL FOR BEGINNERS IN 6 HO...  

PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో)
   • PYTHON - OOPS CONCEPTS | MODULES | EX...  

PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU
   • PYTHON NUMPY TUTORIAL IN TELUGU (తెలు...  

PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE
   • PYTHON PANDAS TUTORIAL IN TELUGU (తెల...  

MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH)
   • MATPLOTLIB LIBRARY - PYTHON PROGRAMMING  

PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL
   • PYTHON DATABASE CONNECTIVITY - MYSQL ...  

DATA STRUCTURES USING PYTHON (ENGLISH)
   • DATA STRUCTURES USING PYTHON  

----------------------------------------------------------------------------------------------
Instagram :   / sundeepsaradhikanthety