1
/
6
鍗?/p>
涓?/p>
绉?/p>
鎶�
澶?/p>
瀛?/p>
銆婃暟鎹簱鎶�鏈笌搴旂敤銆?/p>
瀹為獙鎶ュ憡
涓撲笟鐝骇锛?/p>
瀛︾敓濮撳悕锛?/p>
瀛﹀彿锛?/p>
瀹為獙鍦扮偣锛?/p>
鎸囧鏁欏笀锛?/p>
瀹為獙鏃ユ湡鏃堕棿锛?/p>
涓�銆佸疄楠岄」鐩悕绉帮細
绱㈠紩鍜岃鍥?/p>
浜屻�佸疄楠屽鏃讹細
涓夈�佸疄楠岀洰鐨勶細
1.
瀛︿細浣跨敤
SQL Server
绠＄悊骞冲彴鍜?/p>
Transact-SQL
璇彞
CREATE INDEX
鍒涘缓绱㈠紩銆?/p>
2.
瀛︿細浣跨敤
SQL Server
绠＄悊骞冲彴鏌ョ湅绱㈠紩銆?/p>
3.
瀛︿細浣跨敤
SQL Server
绠＄悊骞冲彴鍜?/p>
Transact-SQL
璇彞
DROP INDEX
鍒犻櫎绱㈠紩銆?/p>
4.
鎺屾彙浣跨敤
SQL Server
绠＄悊骞冲彴鍜?/p>
Transact-SQL
璇彞
CREATE-VIEW
鍒涘缓瑙嗗浘鐨勭敤娉曘�?/p>
5.
浜嗚В瀵圭储寮曞拰瑙嗗浘鏇村悕鐨勭郴缁熷瓨鍌ㄨ繃绋?/p>
sp_rename
鐨勭敤娉曘�?/p>
6.
鎺屾彙浣跨敤
Transact-SQL
璇彞
ALTER VIEW
淇敼瑙嗗浘鐨勬柟娉曘�?/p>
7.
浜嗚В鍒犻櫎瑙嗗浘鐨?/p>
Transact-SQL
璇彞
DROP VIEW
鐨勭敤娉曘�?/p>
鍥涖�佸疄楠屽伐鍏锋垨鐜
浜斻�佸疄楠屽唴瀹广�佹楠ゃ�佷唬鐮佸拰缁撴灉锛?/p>
0.
鍒涘缓
studentsdb
鏁版嵁搴撳強鍏剁浉搴旇〃锛屽苟褰曞叆鏁版嵁銆?/p>
鍦?/p>
SQL
Server
绠＄悊骞冲彴涓婏紝鐐瑰嚮鈥滄柊寤烘煡璇⑩�濇墦寮�鏌ヨ缂栬緫鍣ㄧ獥鍙ｏ紝澶嶅埗绮樿创闄勪欢鈥滃垱
寤烘暟鎹簱浠ｇ爜鈥濅腑鐨勪唬鐮佸埌鏌ヨ缂栬緫鍣ㄧ獥鍙ｏ紝杩愯鍗冲彲鐢熸垚鐩稿叧鏁版嵁搴撳拰琛紝骞舵湁鐩稿簲鐨勬暟
鎹�?/p>
1.
鍒嗗埆浣跨敤
SQL
Server
绠＄悊骞冲彴鍜?/p>
Transact-SQL
璇彞涓?/p>
studentsdb
鏁版嵁搴撶殑
student_info
琛ㄥ拰
curriculum
琛ㄥ垱寤轰富閿储寮曘�?/p>
alter
table
student_info
alter
column
瀛﹀彿
char
(
4
)
not
null;
alter
table
student_info
add
primary
key
(
瀛﹀彿
)
alter
table
curriculum
alter
column
璇剧▼缂栧彿
char
(
4
)
not
null;
alter
table
curriculum
add
primary
key
(
璇剧▼缂栧彿
)
2.
浣跨敤
SQL Server
绠＄悊骞冲彴鎸?/p>
curriculum
琛ㄧ殑璇剧▼缂栧彿鍒楀垱寤哄敮涓�鎬х储寮曘�?/p>
create
unique
index
璇剧▼缂栧彿
_idx
on
curriculum
(
璇剧▼缂栧彿
)
3.
鍒嗗埆浣跨敤
SQL Server
绠＄悊骞冲彴鍜?/p>
Transact-SQL
璇彞涓?/p>
studentsdb
鏁版嵁搴撶殑
grade
琛ㄧ殑
鈥滃垎鏁扳�?/p>
瀛?/p>
娈靛垱寤轰竴涓潪鑱氶泦绱㈠紩锛屽懡鍚嶄负
grade_index
銆?/p>
create
index
grade_index
on
grade
(
鍒嗘暟
)