如何判断服务端的一个表是否存在（100）(100分)

F

fox007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-13

• #1

如题

 

Z

zhumoo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-13

• #2

看sysobjects表是是否有关于他的记录啊。

 

Z

zqs10597249

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-13

• #3

oracle
select * from tab

 

T

tan_jian

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-13

• #4

Oracle
select * from user(all)_tables where tablename='xxxxx';
SQLServer:
sysobjects,objecttype来判断!

 

K

Kinki

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-13

• #5

也可以用TTable的exists属性

 

L

luckchen8256

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-13

• #6

function IsTableExists(Conn: TADOConnection;TableName: string): boolean;
var
sUper: string;
SL: TStringList;
i: integer;
begin
sUper := UpperCase(TableName);
SL := TStringList.Create;
Result := false;
try
Conn.GetTableNames(SL,false);
for i:= 0 to SL.Count -1do
begin
if UpperCase(SL) = sUper then
begin
Result := true;
break;
end;
end;
finally
SL.Free;
end;
end;

 

H

hbezwwl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-13

• #7

通过查询系统表就可以知道表是否存在。