Wednesday, June 29, 2011

How to get entire table name from database

How to get entire table name from database


You can get the entire table name from the database.

SELECT name AS table_name FROM sys.Tables

Using above query you can find entire table name. Suppose In Database there are
three tables like Table A, Table B, Table C. then result will be:

Table A
Table B
Table C

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.