绮惧搧鏂囨。
绮惧搧鏂囨。
甯哥敤缁忓吀
SQL
璇彞澶у叏瀹屾暣鐗?/p>
--
璇﹁В
+
瀹炰緥
涓嬪垪璇彞閮ㄥ垎鏄?/p>
Mssql
璇彞锛屼笉鍙互鍦?/p>
access
涓娇鐢ㄣ�?/p>
SQL
鍒嗙被锛?/p>
DDL
鈥?/p>
鏁版嵁瀹氫箟璇█
(CREATE
锛?/p>
ALTER
锛?/p>
DROP
锛?/p>
DECLARE)
DML
鈥?/p>
鏁版嵁鎿嶇旱璇█
(SELECT
锛?/p>
DELETE
锛?/p>
UPDATE
锛?/p>
INSERT)
DCL
鈥?/p>
鏁版嵁鎺у埗璇█
(GRANT
锛?/p>
REVOKE
锛?/p>
COMMIT
锛?/p>
ROLLBACK)
棣栧厛
,
绠�瑕佷粙缁嶅熀纭�璇彞锛?/p>
1
銆佽鏄庯細鍒涘缓鏁版嵁搴?/p>
CREATE DATABASE database-name
2
銆佽鏄庯細鍒犻櫎鏁版嵁搴?/p>
drop database dbname
3
銆佽鏄庯細澶囦唤
sql server
---
鍒涘缓
澶囦唤鏁版嵁鐨?/p>
device
USE master
EXEC
sp_addumpdevice 鈥檇isk鈥? 鈥檛estBack鈥? 鈥檆:
\mssql7backup\
MyNwind_1.dat鈥?/p>
---
寮�濮?/p>
澶囦唤
BACKUP DATABASE pubs TO testBack
4
銆佽鏄庯細鍒涘缓鏂拌〃
create table tabname(col1 type1 [not null] [primary key],col2 type2 [not
null],..)