Table design of SQL database

According to different databases, the SQL statements for creating tables will be different. Several common database creation methods are as follows:

Create a table. Table name Persons, first column Id_P, integer type; Last name in the second column, character type; The third column name, character type.

Microsoft VS SQL 2008 database

Mysql database

Sqlite database

Extended data:

Structured Query Language (SQL for short) is a standard computer language for accessing and processing databases, and it is also an extension of database script files. Common operations:

Delete table-drop table tabname-this is to delete the table together with the information in the table, but there will be records in the log file;

Delete database-Delete database;

Delete Data Record-"Delete Conditional Expression from Data Table"