求大神帮解决mysql 及sql server
sql server中
DECLARE @STRING VARCHAR(8000)
WHILE EXISTS(SELECT NAME FROM sysobjects WHERE XTYPE='D')
BEGIN
SELECT top 1 @STRING='ALTER TABLE '+B.NAME+' DROP CONSTRAINT '+A.NAME
FROM (SELECT PARENT_OBJ,NAME FROM sysobjects WHERE XTYPE='D') A,
(SELECT ID,NAME FROM sysobjects WHERE OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1) B
WHERE A.PARENT_OBJ=B.ID
EXEC(@STRING)
END
GO
这段代码在mysql中应该怎么写。。。。
跪求大神!!