- 康康map
-
2005?15年前的软件,早淘汰了(居然还有人用?)
对sqlserver,最简单的建库命令为create
database
如:
create
database
Student
而建表要看你要什么字段的,最简单的表为
create
table
stu
(id
integer)
而实际
,建库有N多复杂的参数
的(数据库DBA年薪几十万到上百万不是好拿的)
以下是microsoft官方的建库命令
CREATE
DATABASE
database_name
[
CONTAINMENT
=
{
NONE
|
PARTIAL
}
]
[
ON
[
PRIMARY
]
<filespec>
[
,...n
]
[
,
<filegroup>
[
,...n
]
]
[
LOG
ON
<filespec>
[
,...n
]
]
]
[
COLLATE
collation_name
]
[
WITH
<option>
[,...n
]
]
[;]
<option>
::=
{
FILESTREAM
(
<filestream_option>
[,...n
]
)
|
DEFAULT_FULLTEXT_LANGUAGE
=
{
lcid
|
language_name
|
language_alias
}
|
DEFAULT_LANGUAGE
=
{
lcid
|
language_name
|
language_alias
}
|
NESTED_TRIGGERS
=
{
OFF
|
ON
}
|
TRANSFORM_NOISE_WORDS
=
{
OFF
|
ON}
|
TWO_DIGIT_YEAR_CUTOFF
=
<two_digit_year_cutoff>
|
DB_CHAINING
{
OFF
|
ON
}
|
TRUSTWORTHY
{
OFF
|
ON
}
|
PERSISTENT_LOG_BUFFER=ON
(
DIRECTORY_NAME="<Filepath
to
folder
on
DAX
formatted
volume>"
)
}
<filestream_option>
::=
{
NON_TRANSACTED_ACCESS
=
{
OFF
|
READ_ONLY
|
FULL
}
|
DIRECTORY_NAME
=
"directory_name"
}
<filespec>
::=
{
(
NAME
=
logical_file_name
,
FILENAME
=
{
"os_file_name"
|
"filestream_path"
}
[
,
SIZE
=
size
[
KB
|
MB
|
GB
|
TB
]
]
[
,
MAXSIZE
=
{
max_size
[
KB
|
MB
|
GB
|
TB
]
|
UNLIMITED
}
]
[
,
FILEGROWTH
=
growth_increment
[
KB
|
MB
|
GB
|
TB
|
%
]
]
)
}
<filegroup>
::=
{
FILEGROUP
filegroup
name
[
[
CONTAINS
FILESTREAM
]
[
DEFAULT
]
|
CONTAINS
MEMORY_OPTIMIZED_DATA
]
<filespec>
[
,...n
]
}
<service_broker_option>
::=
{
ENABLE_BROKER
|
NEW_BROKER
|
ERROR_BROKER_CONVERSATIONS
}