SQL
锛氱粨鏋勫寲鏌ヨ璇█锛屾槸鍥介檯鍖栨爣鍑嗙粍缁囬噰绾崇殑鏍囧噯鏁版嵁搴撹瑷�
浣滅敤锛氭暟鎹簱绠＄悊鍛樺彲浠ョ敤鍒╃敤娆¤瑷�鎿嶄綔鏁版嵁搴撶郴缁燂紝鍗筹細
SQL
鏄竴绉嶈兘澶熻鏁版嵁搴撶郴缁熻
鎳傜殑鎿嶄綔璇█銆?/p>
T
鈥?/p>
SQL
鏄井杞叕鍙搁拡瀵?/p>
SQL Server
杩欑鍏崇郴鏁版嵁搴撴墍瀹氫箟鐨勪竴绉?/p>
SQL
璇█锛岀敤鎴峰彲浠ュ畬鎴?/p>
Server
鏁版嵁搴撲腑鐨勬墍鏈夋搷浣溿�?/p>
SQL
鐨勫垎绫伙細
锛?/p>
1
锛夛細鏁版嵁瀹氫箟璇█锛?/p>
DDL
鐢ㄦ潵鍒涘缓鏁版嵁搴撳拰鏁版嵁搴撲腑鐨勫悇绉嶅璞?/p>
鏁版嵁搴撲腑鐨勫璞″寘鎷細琛ㄣ�佽鍥俱�佺储寮曘�佸瓨鍌ㄨ繃绋嬨�佽Е鍙戝櫒
DDL
甯哥敤鐨勫懡浠ゅ寘鎷細
create
銆?/p>
alter
銆?/p>
drop
锛?/p>
2
锛夛細鏁版嵁鎿嶇旱璇█锛?/p>
DML
鍙互瀹屾垚瀵规暟鎹簱涓暟鎹殑鏌ヨ銆佹洿鏂般�佸垹闄ゃ�佹彃鍏ョ殑鍔熻兘
DML
甯哥敤鐨勫懡浠ゅ寘鎷細
select
銆?/p>
update
銆?/p>
delete
銆?/p>
insert
锛?/p>
3
锛夋暟鎹帶鍒惰瑷�锛?/p>
DCL
DCL
甯哥敤鐨勫懡浠ゅ寘鎷細
grant
銆?/p>
revoke
銆?/p>
deny
锛?/p>
4
锛夋暟鎹被鍨?/p>
1
銆佹暟瀛楁暟鎹被鍨?/p>
a
銆佹暣鍨嬫暟鎹被鍨嬶細
bigint
銆?/p>
int
銆?/p>
smallint
銆?/p>
tinyint
b
銆佹诞鐐规暟鎹被鍨嬶細
float
銆?/p>
real
c
銆佸浐瀹氱簿搴︽暟鎹被鍨嬶細
decimal
銆?/p>
numeric
d
銆佽揣甯佹暟鎹被鍨嬶細
money
銆?/p>
smallmoney
灏嗘暟鎹牸寮忚浆鎹㈡垚瀛楃涓叉柟娉曪細
STR(ID;---ID
涓烘暟鎹被鍨嬶紝
STR(ID
涓哄瓧绗︿覆
2
銆佸瓧绗︽暟鎹被鍨嬶細
varchar
銆?/p>
char
銆?/p>
text
銆?/p>
nchar
銆?/p>
nvarchar
銆?/p>
ntext
鍖哄埆
char
鍜?/p>
varchar
鏁版嵁绫诲瀷锛?/p>
char
鏁版嵁绫诲瀷鏄瓨鏀惧浐瀹氶暱搴︾殑瀛楃
Varchar
鏁版嵁绫诲瀷鏄瓨鏀惧姩鎬侀暱搴︾殑瀛楃