新建默認(rèn)值 ALTER TABLE [表名] ADD CONSTRAINT 默認(rèn)值名 DEFAULT ’51WINDOWS.NET’ FOR [字段名]
刪除默認(rèn)值 ALTER TABLE [表名] DROP CONSTRAINT 默認(rèn)值名
刪除Sql Server 中的日志,減小數(shù)據(jù)庫文件大小 dump transaction 數(shù)據(jù)庫名 with no_log backup log 數(shù)據(jù)庫名 with no_log dbcc shrinkdatabase(數(shù)據(jù)庫名) exec sp_dboption ’數(shù)據(jù)庫名’, ’autoshrink’, ’true’
/’添加字段通用函數(shù) Sub AddColumn(TableName,ColumnName,ColumnType) Conn.Execute("Alter Table "&TableName&" Add "&ColumnName&" "&ColumnType&"") End Sub
/’更改字段通用函數(shù) Sub ModColumn(TableName,ColumnName,ColumnType) Conn.Execute("Alter Table "&TableName&" Alter Column "&ColumnName&" "&ColumnType&"") End Sub
/’檢查表是否存在
sql="select count(*) as dida from sysobjects where id = object_id(N’[所有者].[表名]’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1"