find tables

hi, how to find the user table begin with "abc"(abcTB1, abcTB2...) use
query?Hi,
Use the below command:-
sp_tables 'abc%'
Thanks
Hari
SQL Server MVP
"js" <js@.someone.com> wrote in message
news:%234Sq5zJQFHA.3496@.TK2MSFTNGP12.phx.gbl...
> hi, how to find the user table begin with "abc"(abcTB1, abcTB2...) use
> query?
>|||This would help as well:
select * from sysobjects where name like 'abc%'
Thanks
ZS
"Hari Pra" wrote:

> Hi,
> Use the below command:-
> sp_tables 'abc%'
> Thanks
> Hari
> SQL Server MVP
> "js" <js@.someone.com> wrote in message
> news:%234Sq5zJQFHA.3496@.TK2MSFTNGP12.phx.gbl...
>
>|||another is:
select table_name
from information_schema.tables
where table_name like 'abc%'
-oj
"js" <js@.someone.com> wrote in message
news:%234Sq5zJQFHA.3496@.TK2MSFTNGP12.phx.gbl...
> hi, how to find the user table begin with "abc"(abcTB1, abcTB2...) use
> query?
>|||Thanks all,
How to put into a record and loop through them?
"oj" <nospam_ojngo@.home.com> wrote in message
news:ejRZl6LQFHA.3496@.TK2MSFTNGP12.phx.gbl...
> another is:
> select table_name
> from information_schema.tables
> where table_name like 'abc%'
> --
> -oj
>
> "js" <js@.someone.com> wrote in message
> news:%234Sq5zJQFHA.3496@.TK2MSFTNGP12.phx.gbl...
>|||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.
"js" <js@.someone.com> wrote in message
news:%234Sq5zJQFHA.3496@.TK2MSFTNGP12.phx.gbl...
> hi, how to find the user table begin with "abc"(abcTB1, abcTB2...) use
> query?
>