table stucture in SQL SQL>desc <table name> Example: SQL>desc smarttips Name Null Type Id NOT NULL NUMBER(2) Name varchar(10)
Author: Sijo Thomas
Sijo Thomas is an IT professional, web technology enthusiast, and digital content creator with hands-on experience in IT support, website management, SEO, AEO, GEO, digital marketing, and online tools. Through Smart Web Solutions, he creates practical technology guides, free digital tools, Malayalam resources, AI-related content, and easy-to-follow tutorials designed to help everyday users solve real digital problems. His interests include artificial intelligence, web technologies, search optimization, automation, productivity tools, WordPress, and emerging digital trends. Sijo focuses on simplifying technical topics and turning them into clear, useful resources that readers can easily understand and apply. You can explore more of his work at SmartWebSolutions.org.
How to Delete table from databse
Drop table from database SQL>drop table <table name> Example: SQL> drop table smarttips Table dropped
How to Delete all data in the SQL table
Truncate the Table SQL>truncate table <table name> Example: SQL>truncate table smarttips;
How to ALTER table in SQL
ALTER a table in SQL Use the following commands for add,change,drop table fields in SQL. SQL>AlTER TABLE <Table name> <ADD,DROP,CHANGE> <field name> ALTER TABLE `test` ADD `test INT NOT NULL ALTER TABLE `test` DROP `name` ALTER TABLE `test` CHANGE `name` `student_name` INT( 11 ) NOT NULL
How to create a table in SQL
Command or syntax for crating a table in SQL SQL> CREATE TABLE <tablename name>(fieldname datatype(size) PRIMARY KEY); Example:CREATE TABLE STUDENT(stu_number number(2) PRIMARY KEY,stu_name varchar(20));
