string strSQL  = "IF EXISTS (" + 
            "SELECT * " + 
            "FROM northwind.dbo.sysobjects " +  
            "WHERE NAME = 'Picture' " +  
            "AND TYPE = 'u')" + Environment.NewLine +  
            "BEGIN" + Environment.NewLine +  
            "DROP TABLE northwind.dbo.picture" + Environment.NewLine +  
            "END" + Environment.NewLine +  
            "CREATE TABLE Picture (" +  
            "PictureID Int IDENTITY(1,1) NOT NULL," +  
            "[FileName] Varchar(255) NOT NULL," +  
            "Picture Image NOT NULL," +  
            "CONSTRAINT [PK_Picture] PRIMARY KEY CLUSTERED" +  
            "(PictureID))";上面是判断表是否存在并可创建表的代码,你看后修改一下,应该对你有用处!