sql server programming: find tables -- sql server programming

Re: find tables

ZULFIQAR SYED
4/13/2005 8:30:02 PM

sql server programming: This would help as well:

select * from sysobjects where name like 'abc%'

Thanks

ZS

[quoted text, click to view]

Re: find tables

Hari Prasad
4/13/2005 9:55:34 PM

Hi,

Use the below command:-

sp_tables 'abc%'

Thanks
Hari
SQL Server MVP

[quoted text, click to view]

find tables

js
4/13/2005 10:52:16 PM

hi, how to find the user table begin with "abc"(abcTB1, abcTB2...) use
query?

Re: find tables

oj
4/13/2005 11:53:22 PM

another is:
select table_name
from information_schema.tables
where table_name like 'abc%'

--
-oj

[quoted text, click to view]

Re: find tables

js
4/14/2005 9:46:40 AM

Thanks all,
How to put into a record and loop through them?

[quoted text, click to view]

Re: find tables

Wayne Snyder
4/14/2005 10:35:05 AM

You would use a cursor... Cursor examples are documented in Books on line...

--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)

I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.