skip to main
|
skip to sidebar
Monday, March 12, 2012
query to get list of tables from database
Can some one please tell me whats a best way ot get a list of all the tables that are present in a particular database.
Thanksselect table_name from information_schema.tables where TABLE_TYPE = 'BASE TABLE'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Query Syntax
Blog Archive
▼
2012
(489)
▼
March
(402)
query: child of child of child of...: Which are th...
query: child of child of child of...: Which are th...
QUERY: 1 SQL Server restricted access according to...
QUERY: 1 SQL Server restricted access according to...
QUERY: 1 SQL Server restricted access according to...
Query/Workload Generator
Query/View: The 2 newest periods for each indicator
Query/View Question
Query/test for db_owner role?
Query/test for db_owner role?
Query/test for db_owner role?
Query/table tweaking Help
Query/Table Join
Query/SQL help
Query/Reporting Tool for SQL Server Tables
Query/Report processing time
Query/Report Help needed
Query/Report for Owner of all SQL Jobs
query/read database size?
Query.....help
Query.....help
Query.....help
query...
Query.
Query, what's wrong here?
query, special transpose and merge of data
Query, help with where clause to reduce resultset
Query!
Query!
Query your Stored Procs
Query XML type with values from another XML type
Query xml field in Query Plan DMV
Query xml field in Query Plan DMV
query xml datatype
query xml datatype
Query XML datasource
Query written in CODE part is not working
Query written in CODE part is not working
Query Would Run For Ever - No Clue
Query works then later timeouts
Query Works in SQL 2000 but not in SQL 2005
Query Works in SQL 2000 but not in SQL 2005
Query works in QA, but NOT in SQL Server stored pr...
Query Works in QA But not in Code
Query works in access, fails in new SQL Server db
Query works in access, fails in new SQL Server db
Query works in access, fails in new SQL Server db
query works in 2005 but not in 2000
query works in 2005 but not in 2000
query works in 2005 but not in 2000
Query works in 2000 but not 2005
Query works in 2000 but not 2005
Query works in 2000 but not 2005
query works fine outside union, but doesnt work .. .
Query works - sproc fails
Query work on developement sql server 2005 but not...
Query work on developement sql server 2005 but not...
Query work in sql 200 fails in sql 2005
Query word starting with....from string caught in ...
Query word starting with....from string caught in ...
Query Woes!
Query wizard
Query wizard
Query wizard
query without using cursor
Query Without Cursor
Query Without Cursor
Query Without Cursor
Query Within A Query?
Query within a query
query with view locks database (was "Problem with ...
Query with using an Interface between CRM system &...
Query with user-define function John Bell
Query with user-define function John Bell
query with user-define function
Query with user-define function
Query with union no longer updatable in SQL 2005
Query with union
query with time period spanning two days
Query with sub-query still returns unexpected results
Query with sub-query still returns unexpected results
Query with sub-query still returns unexpected results
Query with subqueries
Query with single quotes using OPENROWSET
Query with SELECT and SUBSTRING
Query with recordset
Query with quotation mark.
Query with OR never completes
Query with multiple tables Use of JOIN vs WHERE
Query with multiple tables
Query with multiple ID to check and response...
Query with multiple arguments?
Query with MAX funtion
Query with MAX Date
query with like
Query with Joins problem
query with joins
query with joins
query with joins
Query with index?
►
February
(87)
About Me
wavylookingcvbu
View my complete profile
loan
sql
sql server
sql
sql server
sql
imwebhost
No comments:
Post a Comment