Re: Determining types of fields in ADOTable

Article View: borland.public.cppbuilder.database.ado

Article #4265

Back to borland.public.cppbuilder.database.ado Previous Next

#4265

From: Chris Buys
Date: Thu, 24 Jan 2002 12:54

20 lines
1552 bytes

>     SELECT name FROM YourDB.dbo.systypes
>         where xtype in (select xtype from YourDB.dbo.syscolumns )

Thanks for the info.
I'm currently using this query (MS SQL Sever 7):

 SELECT SAMA.dbo.syscolumns.name, SAMA.dbo.systypes.name,
SAMA.dbo.systypes.xtype
FROM SAMA.dbo.systypes, SAMA.dbo.syscolumns
  WHERE (SAMA.dbo.syscolumns.xtype = SAMA.dbo.systypes.xtype)
      AND (SAMA.dbo.syscolumns.id = 1909581841)

My question is this:  if I were to backup the database and restore it on
another server, will the
syscolumns.id be the same?
--------------------------------------------------------
Chris Buys
Development

HAS Software (Pty) Ltd

Technical Details

Message-ID: <3c50042b_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub1.nntpserver.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3c4fe499_1@dnews> <3c4ffb0a_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ff38677e82a96692
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-01-24 05:04:24 PST
From: "Chris Buys" <chris@h-a-s.co.za>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3c4fe499_1@dnews> <3c4ffb0a_1@dnews>
Subject: Re: Determining types of fields in ADOTable
Date: Thu, 24 Jan 2002 14:54:32 +0200
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
NNTP-Posting-Host: 168.209.28.202
Message-ID: <3c50042b_2@dnews>
X-Trace: dnews 1011876907 168.209.28.202 (24 Jan 2002 04:55:07 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub1.nntpserver.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message