How To List All User Tables In SQL Server



TODO:

Have you ever wanted to list all tables that were user created using T-SQL?

 

SOLUTION:

 

SELECT name FROM SYS.OBJECTS WHERE TYPE='U' order by name

 

 

NOTES:

There are no notes on this topic



Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading