To list the name and details related to the Table or View in a database

Neeks
Posted by Neeks under Sql Server category on | Views : 2015
EXEC sp_tables NULL, DBO , NULL, "'TABLE'" -- To get the details related to the Table in a Database
EXEC sp_tables NULL, DBO , NULL, "'VIEW'" -- To get the details related to View in a database

Comments or Responses

Login to post response