應為我的網速慢,所以分快加入.
1
if
exists
(
select
*
from
dbo.sysobjects
where
id
=
object_id
(N
'
[dbo].[DataZJ]
'
)
and
OBJECTPROPERTY
(id, N
'
IsUserTable
'
)
=
1
)
2
drop
table
[
dbo
]
.
[
DataZJ
]
3
GO
4![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
if
exists
(
select
*
from
dbo.sysobjects
where
id
=
object_id
(N
'
[dbo].[UserZJ]
'
)
and
OBJECTPROPERTY
(id, N
'
IsUserTable
'
)
=
1
)
6
drop
table
[
dbo
]
.
[
UserZJ
]
7
GO
8![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
CREATE
TABLE
[
dbo
]
.
[
DataZJ
]
(
10
[
Meid
]
[
int
]
IDENTITY
(
1
,
1
)
NOT
NULL
,
11
[
xb
]
[
bigint
]
NULL
,
12
[
sr
]
[
datetime
]
NULL
,
13
[
dz
]
[
varchar
]
(
500
) COLLATE Chinese_Taiwan_Stroke_CI_AS
NULL
14
)
ON
[
PRIMARY
]
15
GO
16![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
CREATE
TABLE
[
dbo
]
.
[
UserZJ
]
(
18
[
id
]
[
int
]
IDENTITY
(
1
,
1
)
NOT
NULL
,
19
[
zname
]
[
varchar
]
(
50
) COLLATE Chinese_Taiwan_Stroke_CI_AS
NULL
,
20
[
Meid
]
[
int
]
NULL
21
)
ON
[
PRIMARY
]
22
GO
23![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
24
ALTER
TABLE
[
dbo
]
.
[
DataZJ
]
ADD
25
CONSTRAINT
[
PK_DataZJ
]
PRIMARY
KEY
CLUSTERED
26
(
27
[
Meid
]
28
)
ON
[
PRIMARY
]
29
GO
30![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
31
ALTER
TABLE
[
dbo
]
.
[
UserZJ
]
ADD
32
CONSTRAINT
[
PK_UserZJ
]
PRIMARY
KEY
CLUSTERED
33
(
34
[
id
]
35
)
ON
[
PRIMARY
]
36
GO
37![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
38
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
13
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
14
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
16
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
18
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
19
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
20
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
21
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
22
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
23
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
24
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
25
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
26
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
27
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
28
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
29
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
30
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
31
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
32
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
33
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
34
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
35
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
36
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
37
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
38
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)