Database-Basic Operations and property settings

Database-Basic Operations and property settings
a property setting
1, compatibility level and related property settings: Select the previous level that can be compatible with earlier
compatibility level





**2, separating the database:
Select a database-right-task-detach
Note: Detach is not deleted * *


**3, additional database:
System database-Right-attach-add-Select Database-OK * *


4, Delete:
Right-delete-physically delete from disk
And separation can be restored
5, Data type:
Numeric type:
Int:smallint,bigint,tinint,int Altogether 4 kinds
float: Float type
Currency Type: Money
6, data types bit:0 and 1 are equivalent to Boolean
Allow null: Is NULL, tick not allowed
,
7, change whether NULL is allowed to save error resolution:
Tools-Option-designer****


8, Mark Seed:
The starting size of the indicator

9, indicator increment:
increments for each increment of an indicator

**10, default value: Specifies the default value for the field
When editing a table: An exclamation point appears, right-click Execute SQL * *

Copyright NOTICE: Welcome to Exchange, QQ872785786

Database-Basic Operations and property settings