Shulou(Shulou.com)05/31 Report--

This article introduces how to modify the table structure and delete the table in SQL. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.

1. Create a database table

-- which database to use? if you do not write this sentence is the default database, you can also use the mouse to select the current database use testDB-- to create a table Create Table tablename (--id represents field name-- int data type-- primary key primary key-- not null is not empty-- identity (1) 1) the initial value is 1 self-increasing 1 id int primary key not null identity (1 id int primary key not null identity),-- unique unique name varchar (20) not null unique)

two。 Delete table Drop table table name 3. Modify table structure

-- add column Alter table table name Add column name type-- delete column Alter table table name drop cloumn column name-- modify column, modify column type Alter table table name Alter column column name type

On the SQL language how to modify the table structure and delete the table to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.