#create table sql

The DROP TABLE query is used to drop an existing table on a database. Syntax DROP TABLE tablename;   Note: You must be very careful when using this command because once the table is deleted all the information in that table will also be permanently lost.   Example DROP TABLE students; After using this query the table will be deleted in the database.

The SQL CREATE TABLE statement is used to create a table on the databse. If you want to create a table, you have to name the table and define its column and the data type for each column. Syntax CREATE TABLE tablename ( column-1 datatype, column-2 datatype, column-3 datatype, .... ); The column parameters specify the names of the table columns. The data type parameter specifies the type of data…

If you are familiar with Excel then you will know how a table in RDBMS works, and data is stored in Tables. The next version of Excel is RDBMS Table, and it is useful to start learning about Table and accessing it with SQL. An SQL table consists of scalar (single-value) data arranged in columns and rows. Relational database tables have the following components: A unique table name Unique names…