sscasc@tumkur longtext large text field characters blob normal sized binary large object bytes mediumblob medium sized blob bytes ( mbintroduction to sql statements the standard language for communicating with relational databases is sqlthe structured query language sql is an ansi (american national standards institutestandard computer languagedesigned to be as close to the english language as possiblemaking it an easy language to learn popular database management systems such as oraclesybaseand microsoft sql serverall use sql to actually work with databases and tableswe sql statements commonly used statements includethese sql commands are mainly categorized into three categories as discussed belowdata definition language (ddl)ddl or data definition language actually consists of the sql commands that can be used to define the database schema it simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in database examples of ddl commandscreateis used to create the database or its objects (like tableindexfunctionviewsstore procedure and triggersdropis used to delete objects from the database alteris used to alter the structure of the database truncateis used to remove all records from tableincluding all spaces allocated for the records are removed commentis used to add comments to the data dictionary renameis used to rename an object existing in the database data manipulation language (dml)the sql commands that deals with the manipulation of data present in database belong to dml or data manipulation language and this includes most of the sql statements examples of dmlsp_python programming