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?
>

find fields

hi, how to find the fields have "&abc" as the caption in the database?
thanks...Do you mean the extended property, description?
http://www.aspfaq.com/2244
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"js" <js@.someone.com> wrote in message
news:ONSPaDVRFHA.2252@.TK2MSFTNGP15.phx.gbl...
> hi, how to find the fields have "&abc" as the caption in the database?
> thanks...
>
>|||Thanks Aaron,
I want fo find what fields have the "abc" in what tables as the field
captions.
Can I use a query to get them?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uQJWxnVRFHA.3664@.TK2MSFTNGP15.phx.gbl...
> Do you mean the extended property, description?
> http://www.aspfaq.com/2244
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
> "js" <js@.someone.com> wrote in message
> news:ONSPaDVRFHA.2252@.TK2MSFTNGP15.phx.gbl...
>|||Hi,
Select TABLE_NAME,COLUMN_NAME from FORMATION_SCHEMA.COLUMNS where
COLUMN_NAME like '%ABC%'
You can also query system table SYSCOLUMNS
Thanks
Hari
SQL Server MVP
"js" <js@.someone.com> wrote in message
news:%23zQX4wVRFHA.3476@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron,
> I want fo find what fields have the "abc" in what tables as the field
> captions.
> Can I use a query to get them?
>

> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:uQJWxnVRFHA.3664@.TK2MSFTNGP15.phx.gbl...
>|||> I want fo find what fields have the "abc" in what tables as the field
> captions.
I don't know what you mean by "field captions"... there are no fields and
there are no specific things called captions. There are columns which have
a name and *can* have a description. Can you please be more specific about
what you are looking for.|||That's it. Thanks...
"Hari Pra" <hari_pra_k@.hotmail.com> wrote in message
news:uP%230cIWRFHA.2604@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Select TABLE_NAME,COLUMN_NAME from FORMATION_SCHEMA.COLUMNS where
> COLUMN_NAME like '%ABC%'
> You can also query system table SYSCOLUMNS
> Thanks
> Hari
> SQL Server MVP
>
> "js" <js@.someone.com> wrote in message
> news:%23zQX4wVRFHA.3476@.TK2MSFTNGP10.phx.gbl...
>
>