This Short is About SQL Class Day #07 (SQL series) in Telugu for SQL Developers, Data Analyst and Business Analyst. By Srinivas Reddy Excel Telugu Videos
DDL Command: ALTER Table
ALTER TABLE:
Changing Datatype:
ALTER TABLE emp
ALTER COLUMN eid int;
Changing NULLs:
ALTER TABLE emp ALTER COLUMN eid int NOT NULL;
ADD Column:
Syn:
ALTER TABLE table_name
Add Column_name data_type;
Ex: ALTER TABLE emp
Add EADD VARCHAR(15);
Delete Column:
Syn:
ALTER TABLE Table_name
DROP Column Column_name;
Ex:
ALTER TABLE EMP
DROP COLUMN EADD;
#sql #excel #shorts #telugu #excelteluguvideos #mysql #sqltelugu
Please Follow us on Instagram: / excelteluguvideos
Telegram: https://t.me/EXCELTELUGUVIDEOS