| Author | Message | ||
Maverick Hero Username: Maverick Post Number: 18812 Registered: 01-2008 Posted From: 192.146.101.24 Rating: N/A |
thanks dude.. I hate you Sakshi, DLM at its best | ||
Shikar Junior Artist Username: Shikar Post Number: 3 Registered: 03-2010 Posted From: 151.191.175.207 Rating: N/A |
meeku all_tables ki equivalent tables levu in 2005 or 2008 version. they are now treated as views, you can download the schemeta from here - http://download.microsoft.com/download/0/d/f/0dfe488e-a335-4 480-8a8a-b405e32f4368/SQL2005_Sys_Views.pdf inka meeku kaavali ante... select * from sys.tables, sys.all_columns, sys.all_objects, sys.procedures etc etc views nunchi query cheyya vachu | ||
Shikar Junior Artist Username: Shikar Post Number: 2 Registered: 03-2010 Posted From: 151.191.175.207 Rating: N/A |
books online is the best reference. ledhu anukunte sql server pocket reference ani vuntadi, sit in barnes and noble and quick glance through it. every object table is prefixed with sys*** and system stored procs are prefixed with sp_. inka meeku objects ante system functions vuntayyi. all of them are very well documented under books online. meeru client tools kaani whole server kaani install chesthe you have an option to install books online, it's very helpful. or follow through this link - http://www.microsoft.com/downloads/details.aspx?FamilyId=765 433F7-0983-4D7A-B628-0A98145BCB97&displaylang=en | ||
Maharshi Junior Artist Username: Maharshi Post Number: 725 Registered: 02-2008 Posted From: 69.142.61.161 Rating: N/A |
Some thing like this : select * from Sysobjects where Xtype='U' -- to get the user tables info select * from Sysobjects where Xtype='P' -- To get user Stored procedures info Select * from Systables if not , Purpose ento correct telisthe enka emanna telisthe chepachu. | ||
Maverick Hero Username: Maverick Post Number: 18811 Registered: 01-2008 Posted From: 192.146.101.24 Rating: N/A |
SQL Server quick primer edanna unda? Like info on all the system/metadata tables(like oracle counterpart of ALL_TABLES) etc? I hate you Sakshi, DLM at its best |