Asp Materials,WCF, Sql Server,Interview Question

Friday, 5 June 2015

How to get all tables name from database in SQLServer 2008?

To get all tables names from DataBase:-

select * from information_schema.tables

Select * from SYS.TABLES

No comments:

Post a Comment

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

Subscribe to: Post Comments (Atom)