
06.01.2008, 11:25
|
|
Познающий
Регистрация: 01.01.2008
Сообщений: 50
С нами:
9662713
Репутация:
71
|
|
Сообщение от Spyder
вы синтаксиса sql походу вообще не знаете
Сообщение от Spyder
Дело в том что надо указывать только имя таблицы, без имени бд в которой она находится +)
Сообщение от ISO/IEC 9075:1992, Database Language SQL
Base tables and views are identified by <table name>s. A <table
name> consists of a <schema name> and an <identifier>. For a per-
sistent table, the <schema name> identifies the schema in which
the base table or view identified by the <table name> was de-
fined. Base tables and views defined in different schemas can
have <identifier>s that are equal according to the General Rules
of Subclause 8.2, "<comparison predicate>".
If a reference to a <table name> does not explicitly contain a
<schema name>, then a specific <schema name> is implied. The par-
ticular <schema name> associated with such a <table name> depends
on the context in which the <table name> appears and is governed
by the rules for <qualified name>. The default schema for <prepara-
ble statement>s that are dynamically prepared in the current SQL-
session through the execution of <prepare statement>s and <execute
immediate statement>s is initially implementation-defined but may
be changed by the use of <set schema statement>s.

|
|
|