SQL Server table Operations Introduction _mssql2005

In the database, the table is very important, most of the data are stored in the table, the table's various operations directly affect the data in the database! Below is the table in this chapter of my summary!

The sum of this chapter! The table can be directly manipulated, but also through constraints, rules, default values, etc. to operate on it!

Below is my summary of the direct operation of the table!

The operation of the table, we can also by setting various constraints, to affect it! The bottom is a summary of the effects of setting constraints on the table!

You can also set rules and default values, write to the tables in the database, and the bottom is a summary of the rules and default values!