SQL Server database system collation--creation and management of data tables

Attention:

1. Fixed-length character types take up more space than non-fixed-length character types, but because fixed-length character types do not require length processing when setting field values, it is faster to process.

Therefore, the use of fixed-length character types will improve system performance for relatively fixed length data.

2, change the existing data sheet. Syntax for adding a field: ALTER TABLE name to change the name of the Add field type

3, change the existing data table, delete the syntax of the field: ALTER table name to be changed drop the field name to delete

4. Syntax for deleting data tables: Drop table name to delete

SQL Server database system collation--creation and management of data tables