1 if exists( 2 select * from sysobjects where id=OBJECT_ID(N‘[dbo].[Users]‘) 3 and OBJECTPROPERTY(id, N‘IsUserTable‘)=1 4 ) 5 drop table [dbo].[Users]
1 ALTER TABLE Table_Name 2 ADD Field_Name Data_Type
1 ALTER TABLE Table_Name 2 DROP COLUMN Field_Name
1 select top 10 * from Table_Name order by newid()
原文：http://www.cnblogs.com/a2htray/p/4592785.html