user master if exists(select 1 from sysdatabases where name='test') drop database test if object_id('test.dbo.a') is not null drop table test.dbo.a
USE MASTER GOIF EXISTS(SELECT 1 FROM SYSDATABASES WHERE NAME=N'database_name') DROP DATABASE database_name GO
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE NAME=N'table_name' and type='U') DROP TABLE table_name GO
-- ============================================= -- Basic Create Database Template -- ============================================= IF EXISTS (SELECT * FROM master..sysdatabases WHERE name = N'<database_name, sysname, test_db>') DROP DATABASE <database_name, sysname, test_db> GOCREATE DATABASE <database_name, sysname, test_db> GO------------------------------------------------------------ ============================================= -- Create table basic template -- ============================================= IF EXISTS(SELECT name FROM sysobjects WHERE name = N'<table_name, sysname, test_table>' AND type = 'U') DROP TABLE <table_name, sysname, test_table> GOCREATE TABLE <table_name, sysname, test_table> ( <column_1, sysname, c1> <datatype_for_column_1, , int> NULL, <column_2, sysname, c2> <datatype_for_column_2, , int> NOT NULL) GO----------------------------------------这个都可以在查询分析器中得到,查询分析器->新建->create table/datebase
if exists (select * from sysobject where id = object_id('表名')) drop table 表名 if exists (select * from sysdatabases where name = '資料庫名') DROP DATABASE 資料庫名
if exists(select * from master.dbo.sysdatabases where name='test') drop database test if exists(select * from sysobjects where name=N'tablename' and type='u') drop table tablename
if exists(select 1 from sysdatabases where name='test')
drop database test
if object_id('test.dbo.a') is not null
drop table test.dbo.a
GOIF EXISTS(SELECT 1 FROM SYSDATABASES WHERE NAME=N'database_name')
DROP DATABASE database_name
GO
DROP TABLE table_name
GO
-- Basic Create Database Template
-- =============================================
IF EXISTS (SELECT *
FROM master..sysdatabases
WHERE name = N'<database_name, sysname, test_db>')
DROP DATABASE <database_name, sysname, test_db>
GOCREATE DATABASE <database_name, sysname, test_db>
GO------------------------------------------------------------ =============================================
-- Create table basic template
-- =============================================
IF EXISTS(SELECT name
FROM sysobjects
WHERE name = N'<table_name, sysname, test_table>'
AND type = 'U')
DROP TABLE <table_name, sysname, test_table>
GOCREATE TABLE <table_name, sysname, test_table> (
<column_1, sysname, c1> <datatype_for_column_1, , int> NULL,
<column_2, sysname, c2> <datatype_for_column_2, , int> NOT NULL)
GO----------------------------------------这个都可以在查询分析器中得到,查询分析器->新建->create table/datebase
drop table 表名
if exists (select * from sysdatabases where name = '資料庫名')
DROP DATABASE 資料庫名
drop database test
if exists(select * from sysobjects where name=N'tablename' and type='u')
drop table tablename
然后“所有任务”-“生成SQL语句”,然后保存为一个文件
用记事本打开看看里面的代码,参考一下,你就懂了。