1，建新表：
USE [YOUR_DB_NAME]GOIF EXISTS (SELECT * FROM SYSOBJECTS WHERE [NAME] = 'YOUR_TABLE_NAME' AND XTYPE='U') BEGIN DROP TABLE [YOUR_TABLE_NAME]ENDGOCREATE TABLE [dbo].[YOUR_TABLE_NAME]( FIELD1 VARCHAR(20), ---)GO
2, 修改某个字段
USE [YOUR_DB_NAME]GOIF( EXISTS( SELECT TOP 1 1 FROM SYSCOLUMNS WHERE ID = ( SELECT ID FROM SYSOBJECTS WHERE TYPE='U' AND NAME='YOUR_TABLE_NAME') AND NAME = 'YOUR_FIELD_NAME'))BEGIN --print 'exist' ALTER TABLE [dbo].[YOUR_TABLE_NAME] ALTER COLUMN [YOUR_FIELD_NAME] varchar(50) NULLEND
3，新建临时表
USE MASTER GO if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#tmpResult')) begin drop table #tmpResult end create table #tmpResult ( DbName varchar(100), SpOrViewName varchar(100), [Type] varchar(2), Content varchar(100) ) go