Alter Commands Of SQL

ALTER COMMANDS

Hey Guys Welcome to our New post

IN PREVIOUS BLOG

In our previous Blog we learn about the commands of sql which was used to create data base or creating a table in our previous blog we learnt that how to create a data base and we also learn about that how to use that data base which we created

IN TODAY'S BLOG

In this blog we learn more commands of the SQL now with out any delay lets starts the today's blog -

Now to check the structure of the table we need to use the command DESC and in this command the DESC will represent the description if we need to use this command we write the DESC than the table name , suppose a table student and i wish to check the description of the table than i enter the command that DESC STUDENT now the description command will briefly tell you about the rows and columns you generated at the time of creating table and now in the most simple language DESC command will show the structure of the table and in that structure you will able to see the descripttion of the table you created .
for example - DESC STUDENT ;

Now to add the column in the table we need to use the keyword ALTER in our previous blogs i also tells you about the ALTER and to know more about the ALTER command you need to visit our previous blog .
Suppose you created a table and you forget to add a column now to add the column without deleting the table you need to use the command ALTER .
for example - ALTER TABLE ( table name ) ADD ( column you wish to add ) ;
Suppose there is a table student and you need to add the column of admission date and now to add that admission date you need to write the command -

ALTER TABLE STUDENT ADD ( ADM_D  DATE ( 8 ) ) ;
 In sql there is a string to add the date the string is also a date in the above command ALTER command is to add or modify some thing in the table and the ADM_D represents the admission date which was the Column we need to ADD in the table and date is the variable which was used to enter the date in the sql and the 8 in the brackets represents that the date will not exceed more than 8 characters now this was all about todays blog . Thank you


IN THE NEXT BLOG WE LEARN MORE ABOUT THE DDL IN THE SQL AND OTHER COMMANDS AND THE OTHER WORKING  IN PYTHON AND OTHER IMPORTANT SUB TOPICS . THANK YOU FOR VISITING , KEEP LEARNING STAY TUNED FOR NEXT BLOG , FOLLOW OUR BLOG FOR REGULAR UPDATES , VIEW OUR PREVIOUS BLOG FOR THE BASIC CONCEPTS OF PYTHON AND OTHER BASIC CONCEPTS OF COMPUTER AND ALSO FOR THE IMPORTANT DEFINITIONS OF THE SQL , VISIT OUR SECOND BLOG – indianbasics.blogspot.com , VISIT OUR YOUTUBE CHANNEL -  Learn Python Our youtube channel will give you the short motivational speeches of the great person in the present there is only five motivational videos on channel but in future I will upload the motivational videos soon .VISIT OUR INSTAGRAM PAGE – instagram.com/learnpython16 , Our instagram page is also a new page i just created few days ago but stay tuned I will upload the post very soon . Please support us by following our blog and by subscribing our youtube channel and by following our instagram page .