摘要:
创建数据库 创建之前判断该数据库是否存在 if exists (select * from sysdatabases where name='databaseName') drop database databaseName go Create DATABASE database-name 删除数据库 drop database dbname 备份sql server --- 创建 备份数据的 device USE master EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1. 阅读全文
摘要:
--1. 获取表的基本字段属性SELECT syscolumns.name,systypes.name,syscolumns.isnullable, syscolumns.length FROM syscolumns, systypes WHERE syscolumns.xusertype = systypes.xusertype AND syscolumns.id = object_id('inventory')2. sql modules SELECT sm.object_id, OBJECT_NAME(sm.object_id) AS object_name, o.type, o. 阅读全文
摘要:
1.判断和删除约束(Constrains) IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[FK_table1_table2]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1 ) ALTER TABLE dbo.table1 DROP CONSTRAINT FK_table1_table2 if (object_id('FK_StockOut_SALESORDER') is not null) begin alter table Stockout dro 阅读全文