Login    Register      

sql querry Posted Date: 10 Jul 2006      Posted By:: damodar     Member Level: Bronze    Member Rank: 0     Points: 2   Responses: 11
what is the querry to get all the tables in a database? Tweet
Responses
#62426    Author: ManoKarthikeyan      Member Level: Silver      Member Rank: 2894     Date: 10/Jul/2006   Rating:     Points: 2 show tables;   #62427    Author: vishal       Member Level: Gold      Member Rank: 509     Date: 10/Jul/2006   Rating:     Points: 2 To get all tables in the database you can write select statement as – SELECT * FROM sysObjects where xtype = ‘U’ U means user tables   #62530    Author: Vimal Verma      Member Level: Gold      Member Rank: 1533     Date: 10/Jul/2006   Rating:     Points: 2 select * from sys.tables   #306046    Author: divya      Member Level: Gold      Member Rank: 366     Date: 13/Oct/2008   Rating:     Points: 1 select * from sysObjects where Xtype='U' or select * from sys.tables where type='U'   #306318    Author: Kavitha      Member Level: Silver      Member Rank: 1784     Date: 13/Oct/2008   Rating:     Points: 1 To get all the tables, use sp_tables in a paticuler DB. Regards, Kavitha N   #314207    Author: Deepika Haridas      Member Level: Gold      Member Rank: 7     Date: 07/Nov/2008   Rating:     Points: 0 show tables; Thanks & Regards, Deepika - Sr. Editor Webmaster, GujaratSpider http://angeldeeps.blogspot.com/ "Experience is the name everyone gives to his mistakes" GujaratSpider - Post and Earn   #314523    Author: Mohammed Najmuddin      Member Level: Gold      Member Rank: 968     Date: 10/Nov/2008   Rating:     Points: 1 This will display information of all tables . select * from information_schema.tables;   #315527    Author: B. Gopal Surya Prakash      Member Level: Silver      Member Rank: 865     Date: 11/Nov/2008   Rating:     Points: 5 Below queries gives only objects in table select * from sysObjects You can different objects based on XType field in where clause for User Tables Xtype = 'U' for View Xtype='V' for procedures Xtype='P' for Scalar Functions Xtype = 'FN' Below query gives tables & view information select * from information_schema.Tables Below query gives View & View text information select * from information_schema.Tables   #316614    Author: Rajalakshmi      Member Level: Silver      Member Rank: 0     Date: 13/Nov/2008   Rating:     Points: 1 hi... Simply u use the query sp_tables under ur database   #318269    Author: Sravya      Member Level: Gold      Member Rank: 477     Date: 18/Nov/2008   Rating:     Points: 1 sql server 2000 select name from sysobjects where type ='u' it will display only tables   #318624    Author: Sriman N Vangala      Member Level: Gold      Member Rank: 119     Date: 19/Nov/2008   Rating:     Points: 4 Various alternatives are there in order to get all the tables information In sql server 2005, we can use the following sp_tables or SELECT * FROM sys.Objects where type = 'U' or select * from sys.tables or select * from information_schema.tables where table_type= 'BASE TABLE' In sql server 2000, we can use the following SELECT * FROM sysObjects where xtype = 'U'
Post Reply
This thread is locked for new responses. Please post your comments and questions as a separate thread. If required, refer to the URL of this page in your new post.
Tweet

Next : Horizontal Scroll Bar for a listview control Previous : sql querry interview question Return to Discussion Forum Post New Message Category:

Related Messages Is there any expert to solve this? what is difference between String and string(data type) in c#? what is a resource file... Horizontal Scroll Bar for a listview control