建库: IF EXISTS (SELECT * FROM master..sysdatabases WHERE name = N'<database_name, sysname, test_db>') DROP DATABASE <database_name, sysname, test_db> GO CREATE DATABASE <database_name, sysname, test_db> GO 建表: IF EXISTS(SELECT name FROM sysobjects WHERE name = N'<table_name, sysname, test_table>' AND type = 'U') DROP TABLE <table_name, sysname, test_table> GO CREATE 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
IF EXISTS (SELECT *
FROM master..sysdatabases
WHERE name = N'<database_name, sysname, test_db>')
DROP DATABASE <database_name, sysname, test_db>
GO CREATE DATABASE <database_name, sysname, test_db>
GO
建表: IF EXISTS(SELECT name
FROM sysobjects
WHERE name = N'<table_name, sysname, test_table>'
AND type = 'U')
DROP TABLE <table_name, sysname, test_table>
GO CREATE 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