Re: [SQL] Problem with stored procedure

Patrice OLIVER wrote: Hello, In this example, I use 2 tables : create table types ( typnum integer primary key, catcode varchar(2), typlib varchar(35)); create table uv ( uvnum varchar(5) primary key, typnum integer, uvlib varchar(50)); alter table uv add constraint fk_uv_type foreign key (typnum

[SQL] retrieve the tables names based on the owner

Hi guys, How can I retrieve (with a query) from a database, only the table names based on the owner name? Many Thanks Antonis ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster