SQL Server Table Management _ about the operation of the table and adding and modifying the operation of the detailed (case code)

SQL Server Table Management _ about the operation of the table and adding and modifying the operation of the detailed (case code)Overview:

Tables consist of rows and columns, and each table must have a table name.

SQL CREATE TABLE Syntax

CREATE TABLE table_name (column_name1 data_type (size), column_name2 data_type (size), Column_name3 data_type (size),....);

1. View Table

exec sp_help table1;

2. Create a table

Create Table table1 (    varchar());

3, modify the table

1. Modify the table table1 to increase the name length to 40.

Alter Table Alter column varchar (a);

2. Modify table table1, add sex column, gender.

Alter Table Add varchar (a);

4. Delete a table

Drop table table1;

is not so esay!!!!

SQL Server Table Management _ about the operation of the table and adding and modifying the operation of the detailed (case code)