新建默認值 ALTER TABLE [表名] ADD CONSTRAINT 默認值名 DEFAULT ’51WINDOWS.NET’ FOR [字段名]
刪除默認值 ALTER TABLE [表名] DROP CONSTRAINT 默認值名
刪除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"
set rs=conn.execute(sql)
response.write rs("dida")’返回一個數(shù)值，0代表沒有，1代表存在
判斷表的存在: select * from sysobjects where id = object_id(N’[dbo].[tablename]’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1
某個表的結構 select * from syscolumns where id = object_id(N’[dbo].[你的表名]’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1
