Getting all the Table Names(User tables) in Sql Server

Rajesh_Kumar
Posted by Rajesh_Kumar under Sql Server category on | Points: 40 | Views : 464
SELECT name AS table_name
,SCHEMA_NAME(schema_id) AS schema_name
,type_desc
FROM sys.objects
WHERE type_desc LIKE '%User_Table%';

Comments or Responses

Login to post response