The following content is required to understand the table in SQL Server. As for the knowledge points, I will detail them one by one in future articles!
Table
1.
Create Table:Create Table DBO. Customer (cust_id int, cust_name char (12), cust_phone char (11 ))
Explanation: A. The full name of a table shoshould have three parts, in the following form:
Database. schema. tablenameB. "DBO" represented
Schema.
2.
Data Types in SQL Server 2005:1) numeric data types2) Date and Time data types3) character data types4) miscellaneous data types5) binary data types6) Bit Data type7) Large Object Data types8) cursor data type9) rowversion data type10) SQL _variant data type11) Table Data type12) XML data type13) uniqueidentifier data type14) user-defined data types15) CLR Data Types
3.
Identity Property
4.
Internal Storage
5.
Constrains1) Primary key2) Foreign key3) Unique key4) Check key5) default key