carpe2 Posted February 20, 2004 Posted February 20, 2004 Hi, i´d like to write a sql sentence which returns all the tables i have created in a data base.... Thanks in advance. Quote Adolfo.
Moderators Robby Posted February 20, 2004 Moderators Posted February 20, 2004 SQL Server, Access, mySql ???? Quote Visit...Bassic Software
carpe2 Posted February 21, 2004 Author Posted February 21, 2004 I´m using sql server 2000... Thanks in advance for any help. Quote Adolfo.
Administrators PlausiblyDamp Posted February 21, 2004 Administrators Posted February 21, 2004 select * from information_schema.tables where table_type ='BASE TABLE' Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
carpe2 Posted February 23, 2004 Author Posted February 23, 2004 Thank you very much, it returns all the data tables i have created and the dtproperties table, too..... Quote Adolfo.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.