Developer's Choice
Monday, 25 July 2011
SQL SERVER
FIND NAME OF DATABASE IN SQL SERVER
select * from sys.databases
FIND NAME OF TABLES IN DATABASE
use DATABASE_NAME
go
select * from sys.tables
go
FETCH DATA FROM A TABLE
SELECT * FROM TABLE_NAME
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment