如何通过.txt文件恢复数据库结构?以下是.txt文件的部分内容:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书丢失_图书编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[图书丢失] DROP CONSTRAINT 图书丢失_图书编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书丢失_图书编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[图书丢失] DROP CONSTRAINT 图书丢失_图书编号_fk
GO
不过你的这个txt应该加上use 数据库osql -S服务器名 -U用户 -P密码 -i你这个txt路径
set @Path='D:\'
set @filename='aa.txt'
create table #(sql varchar(8000))
insert into # exec('select * from OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''Text;HDR=NO;Database='+@Path+';'',''SELECT * FROM '+@filename+''')' )declare corname cursor for select [sql] from #
declare @sql varchar(8000)
open corname
fetch next from corname into @sql
WHILE @@fetch_status = 0
begin
exec(@sql)
fetch next from corname into @sql
end
close corname
deallocate corname改路径和文件名,执行ok