From: lz John <oceanlz@yahoo.com.cn>
To: pgsql-sql@postgresql.org
Subject: hi
Date: Wed, 16 Oct 2002 11:11:42 +0800 (CST)
Message-ID: <20021016031142.34492.qmail@web15106.mail.bjs.yahoo.com> (raw)
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!?
雅虎娱乐新鲜到底,电子周报快乐到家!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oceanlz@yahoo.com.cn
Subject: Re: hi
In-Reply-To: <20021016031142.34492.qmail@web15106.mail.bjs.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox