求使用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语句

--'在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 命令删除数据库

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

SQL删除语句，删除行，列，表…

/*---为表新增一个列ALTER TABLE S ADD CLASS_NO CHAR(6)---*/ /*--更改列的属性,更改数据类型 ALTER TABLE a ALTER Column username NVARCHAR(30)*//*--删除一列 ALTER TABLE a DROP COLUMN username*//* 更改列名EXEC sp_rename '表名.列名','新列名','column' *//**改表名exec sp_rename 'test2', 'test3','OBJECT'**//*删除表drop tablename*/