删除数据库的sql语句

如何删除数据库的记录 sql语句

--'在SQL2008中清除日志就必须在简单模式下进行，等清除动作完毕再调回到完全模式。USE [master]GOALTER DATABASE DNName SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE DNName SET RECOVERY SIMPLE --简单模式GOUSE DNNameGODBCC SHRINKFILE (N'DNName_Log' , 11, TRUNCATEONLY) GOUSE [master]GOALTER DATABASE DNName SET RECOVERY FULL WITH NO_WAITGOALTER DATABASE DNName SET RECOVERY FULL --还原为完全模式GO

求使用sql语句创建和删除数据库的代码

建数据库文件 create database mydb on primary ( name = mydb_data1, filename = 'd:\sql data\mydb_data1.mdf', size = 1, maxsize = unlimited, filegrowth = 10% ), filegroup data2 ( name = mydb_data2, filename = 'd:\sql data\mydb_data2.ndf', size = 2, maxsize = 100, filegrowth = 1 ), filegroup data3 ( name = mydb_data3, filename = 'd:\sql data\mydb_data3.ndf', size = 3, maxsize = 50, filegrowth = 500kb ) log on

SQL..如何用命令删除数据库中所有的表?

要删除所有的用户表:declare @sql varchar(8000)SELECT @sql='drop table ' + name FROM sysobjectsWHERE (type = 'U')ORDER BY 'drop table ' + nameexec(@sql) 如果要删除所有用户表中的内容,可以执行以下语句:declare @sql varchar(8000)SELECT @sql='truncate table ' + name FROM sysobjectsWHERE (type = 'U')ORDER BY 'truncate table ' + nameexec(@sql) 慎用!

sql 命令删除数据库

写个存储过程就都删了。。。。用like 匹配一下 xx_ 的表名