SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE MSysObjects.Name Not Like "MsyS*" AND MSysObjects.Type=1
ORDER BY MSysObjects.Name;
Where
type can be changed as per object
type.
MSysObjects.Type=1
Like
Type is:
1 for Tables
5 for Queries
-32766 for Mocros
-32756 for DAP
-32761 for Modules
I am a Dot Net Developer working in MNC. I am interested to learn new technologies. I am always trying to improve my skills.
MCTS:ASP.NET 3.5
MCTS:WCF 3.5
Submit an article or tip
