USE YourDBName
GO
SELECT *
FROM sys.Tables
GO
This will return all the tables in the database which user have created.
http://blog.sqlauthority.com/2007/06/26/sql-server-2005-list-all-tables-of-database/
Subscribe to:
Post Comments (Atom)
USE YourDBName
GO
SELECT *
FROM sys.Tables
GO
This will return all the tables in the database which user have created.
http://blog.sqlauthority.com/2007/06/26/sql-server-2005-list-all-tables-of-database/
No comments:
Post a Comment