ALTERTABLEtable_nameALTERCOLUMNcolumn_name datatype (5)删除字段: 1 ALTERTABLEtable_nameDROPCOLUMNcolumn_name 3、删除 1 DROPTABLE`test`; 二、视图相关 1、创建 1 2 3 4 5 6 7 8 9 10 11 12 13 14 USE [test] GO SETANSI_NULLSON GO SETQUOTED_IDENTIFIERON GO --注释卸载这儿 CREATEVIEWview...
2. 3、删除 DROPVIEWview_name 1. 三、索引相关 1、创建 (1)在表上创建一个简单的索引 USE[test]GOCREATENONCLUSTEREDINDEXindex_nameONtable_name(column_nameASC,column_name2DESC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,SORT_IN_TEMPDB=OFF,DROP_EXISTING=OFF,ONLINE=OFF,ALLOW_ROW_LOCKS=ON,ALLOW...