i'd like to tranfer sql schema from MS server<br />Example:<br
/>*******************1*********************************<br/>if exists (select * from sysobjects <br />where id =
object_id(N'[admin].[test]')and <br />OBJECTPROPERTY(id, N'IsUserTable') = 1)<br />drop table [admin].[test] <br
/>go<br/>*******************2*********************************<br />CREATE TABLE [admin].[test] (<br />[test_name]
[char](50) NOT NULL ,<br />[test_value] [int] NOT NULL <br />)<br /><br />i can only realize part 2 and must need the
fuctionthat can check data table. <br />create table test(<br />test_name char (50) not null,<br />test_value int not
null<br/>)<br />thanks for any advice!!<br /><p><br /><hr size="1" /><b>Do You Yahoo!?</b><br /><a
href="http://rd.yahoo.com/mail_cn/tag/?http://cn.ent.yahoo.com/newsletter/index.html">雅虎娱乐新鲜到底,电子周报快乐到家!</a>
