create table student ( student-Name varchar ( 20 ) , roll int Not Null , student-Address varchar ( 30 ) ) ;
If you want to verify this query than you can do with the Desc statemtent Syntax
Desc student ; // it describe the entire structure of the table student .
SQL Drop Table
Using SQL drop query you can delete a table and their data from database . Note -> Once you deleted your table and data Using this statement then you cann't recover that table and data. It will not be available in the table forever . Syntax ->
Drop table TableName ;
SQL Delete Table
Using SQL delete query you can delete a row and columne from tha table . If you want to remove specific row or column then you can usign this statement . Note -> Once you deleted your data Using this statement then you can recover that table and data. . Syntax ->