What is the query to list all the tables in database in SQL Server 2000?
Thanks in advance!
What is the query to list all the tables in database in SQL Server 2000?
Thanks in advance!
Select * from sysobjects where xtype in ('u', 's') as u stand for usercreated table and s stand for systemgenerated table