Re: How do I get a list of available tables?
From: Rohtash Kapoor (rohtash_nospam_at_sqlmantra.com)
Date: 03/10/04
- Next message: Will T: "Re: Sharing Tables between Databases"
- Previous message: Adam Machanic: "Re: How do I get a list of available tables?"
- In reply to: James C: "How do I get a list of available tables?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 10 Mar 2004 08:14:11 -0800
USE Northwind
--This will list all the Tables
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
--This will list all the Tables which have term 'Customer' in the name
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_NAME LIKE '%Customer%'
--- Rohtash Kapoor http://www.sqlmantra.com "James C" <jchin@vansco.ca> wrote in message news:8504E7E4-3584-4D62-9603-1A7A3388169A@microsoft.com... > How do I get a list of tables that contain specific text in the name of the table? Is this even possible?
- Next message: Will T: "Re: Sharing Tables between Databases"
- Previous message: Adam Machanic: "Re: How do I get a list of available tables?"
- In reply to: James C: "How do I get a list of available tables?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
