Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 seek to find a table

Author  Topic 

turkalpk
Starting Member

21 Posts

Posted - 2006-05-18 : 01:58:22
Hello I want to seek and find the table named NewCustomer from the database so what would be the query ?

F16 LÝGHTÝNÝNNNG

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-05-18 : 02:01:03
Select * From Information_Schema.Tables Where Table_Name Like '%NewCustomer%'

If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-05-18 : 02:22:52
Select * From Information_Schema.Tables Where Table_Name ='NewCustomer'

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -