Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id B2EF1475F7F
	for <pgsql-sql@postgresql.org>; Tue, 15 Oct 2002 23:11:43 -0400 (EDT)
Received: from web15106.mail.bjs.yahoo.com (unknown [61.135.128.151])
	by postgresql.org (Postfix) with SMTP id 27477475E75
	for <pgsql-sql@postgresql.org>; Tue, 15 Oct 2002 23:11:41 -0400 (EDT)
Message-ID: <20021016031142.34492.qmail@web15106.mail.bjs.yahoo.com>
Received: from [61.152.125.82] by web15106.mail.bjs.yahoo.com via HTTP;
	Wed, 16 Oct 2002 11:11:42 CST
Date: Wed, 16 Oct 2002 11:11:42 +0800 (CST)
From: =?gb2312?q?lz=20John?= <oceanlz@yahoo.com.cn>
Subject: hi
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1283634865-1034737902=:32999"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/219
X-Sequence-Number: 9936

--0-1283634865-1034737902=:32999
Content-Type: text/plain; charset=gb2312
Content-Transfer-Encoding: 8bit

i'd like to tranfer sql schema from MS server
Example:
*******************1*********************************
if exists (select * from sysobjects 
where id = object_id(N'[admin].[test]') and 
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [admin].[test] 
go
*******************2*********************************
CREATE TABLE [admin].[test] (
[test_name] [char] (50) NOT NULL ,
[test_value] [int] NOT NULL 
)

i can only realize part 2 and must need the fuction that can check data table.  
create table test(
test_name char (50) not null,
test_value int not null
)
thanks for any advice!!



---------------------------------
Do You Yahoo!?
雅虎娱乐新鲜到底,电子周报快乐到家!
--0-1283634865-1034737902=:32999
Content-Type: text/html; charset=gb2312
Content-Transfer-Encoding: 8bit

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 fuction that can check data table.&nbsp; <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>
--0-1283634865-1034737902=:32999--