sql creates tables, modifies table structures, and deletes tables
Dec 03, 2016 am 10:49 AM1. Create a database table
--Which database to use, if you don’t write this sentence, it is the default database, you can also use the mouse to select the current database
use testDB
--Create table
Create Table tablename
(
.
id int primary key not null identity(1,1), --unique name varchar(20) not null unique ) 2. Delete tableDrop table table name3. Modify the table structure--Add columnAlter table table nameAdd column name type--Delete columnAlter table table name drop cloumn column name--Modify column, modify column TypeAlter table table nameAlter column column name type

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

What is the difference between HQL and SQL in Hibernate framework?

Usage of division operation in Oracle SQL

What does the identity attribute in SQL mean?

Comparison and differences of SQL syntax between Oracle and DB2

Detailed explanation of the Set tag function in MyBatis dynamic SQL tags

How does Java use the MySQL driver interceptor to implement SQL time-consuming calculations?

How SpringBoot encrypts the SQL account password of the configuration file
