yszwn的专栏

<br />键名    从表    外键列   主表<br /> <br />select fk.name fkname , ftable.name ftablename, cn.name fkcol, rtable.name ftablename from sysforeignkeys <br />  join sysobjects fk <br />    on sysforeignkeys.constid = fk.id <br />  join sysobjects ftable <br />   

<br />IF EXISTS(SELECT * FROM [dbo].[sysobjects] WHERE parent_obj = object_id(N'TableName') AND object_name(id)=N'DF_TableName_ColumnName')<br />    ALTER TABLE [dbo].[TableName] DROP CONSTRAINT [DF_TableName_ColumnName]<br />GO<br /> <br />ALTER TABLE [db

<br />-- =============================================================================<br />-- Title: 在SQL中分类合并数据行<br />-- Author: dobear        Mail(MSN): dobear_0922@hotmail.com<br />-- Environment: Vista + SQL2005<br />-- Date: 2008-04-22<br />-- ======