2

I have a lot of tables in my database (Microsoft Sql Server), and I want to create some kind of list, about my tables. I don't want to write all of the tables' names, I thought there is a way, to create a list about the names of the tables in Microsoft Sql Server Management Studio. Maybe a query which gives me the table names? Thank you!

victorio
  • 6,224
  • 24
  • 77
  • 113

1 Answers1

2

Try something like this:

SELECT NAME 
FROM   DATABASENAME.SYS.TABLES 
ORDER  BY NAME
Gidil
  • 4,137
  • 2
  • 34
  • 50
victorio
  • 6,224
  • 24
  • 77
  • 113