Home > SQL Server > Select table name from Sql Server

Select table name from Sql Server

try this :

select * from sysobjects where xtype = ‘U’

you will get all table name in database that you focus

and try

select * from sysobjects where xtype = ‘U’ order by uid asc, name asc

you will get the name list like the left tab of sql server

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Categories: SQL Server Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.