Showing posts with label get total tables in database. Show all posts
Showing posts with label get total tables in database. Show all posts

19 September 2011

get the list of tables that r available in a particular database in sqlserver

select * from information_schema.tables
or
select * from sys.tables
or
sp_tables