473,666 Members | 2,225 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server 2005 Metadata

N002213F
39 New Member
Does SQL Server 2005 have system tables that you can select to see meta data about a table? I have seem such tables in Oracle.

I would like to retrieve certain tables properties for analysis and comparisons

Any pointers most appreciated
Oct 27 '08 #1
5 1909
debasisdas
8,127 Recognized Expert Expert
yes those are also available here.
Oct 27 '08 #2
N002213F
39 New Member
Some names or web page might help.

Thanks in advance
Oct 27 '08 #3
ck9663
2,878 Recognized Expert Specialist
Depending on the version of SQL Server you're working on, there's a table called sysobjects.

If you're working with SQL 2005, there's a view called sys.tables

So, try the following:

Expand|Select|Wrap|Line Numbers
  1. select * from sys.tables
  2.  
  3. select * from sysobjects

-- CK
Oct 27 '08 #4
N002213F
39 New Member
Found it;
Expand|Select|Wrap|Line Numbers
  1. SELECT NAME FROM SYS.TABLES ORDER BY NAME
and
Expand|Select|Wrap|Line Numbers
  1. EXEC SP_SPACEUSED[TABLENAME]
I used Java to do the the looping, will look at using SQL procedures.
Oct 28 '08 #5
N002213F
39 New Member
Depending on the version of SQL Server you're working on, there's a table called sysobjects.

If you're working with SQL 2005, there's a view called sys.tables

So, try the following:

Expand|Select|Wrap|Line Numbers
  1. select * from sys.tables
  2.  
  3. select * from sysobjects

-- CK
Thanks, if selecting from the sysobjects, one may have to specify the type, lest you get all the objects.
Oct 28 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2973
by: Carl | last post by:
Be careful when implementing views (from SQL Server 97/2K). SQL Server stores the metadata on the view at creation (or the last time it was saved). This means if you have: SELECT * FROM table1 it will put all the fields of table1 in the view's metadata. If you then change table1 and add (for example) another field, this field will not be visible in the view until you open it in design view and click save (to update it).
5
3647
by: Phil Grimpo | last post by:
I have a very odd situation here. I have an administration page, where based on a users permissions, a recordset is called from the SQL server which has a list of paths to "Module Menus". Each of these menus are then placed into the page by calling Server.Execute(rs_Modules("ModulePath")). This works fine for up to 15 "menus" After that, the session variables that were set (not including those called by Global.ASA) are no longer set. ...
4
9438
by: jas | last post by:
I have a basic client/server socket situation setup....where the server accepts a connection and then waits for commands. On the client side, I create a socket, connect to the server...then I pass the socket to a class which just reads from the socket (in a thread). class Reader(Thread): def run(self): while 1:
2
1000
by: Steve Franks | last post by:
Hi All, The following code was working just fine in Visual Studio 2005 Beta 2, but breaks now that I've upgraded to the RC build: public void setMetaValues(string metaKey, string metaVal) { HtmlMeta metadata = new HtmlMeta(); metadata.Attributes.Add(metaKey, metaVal); Page.Header.AddParsedSubObject(metadata);
2
6539
by: kharless | last post by:
Greetings, If I use a "select into" to clone a table, all attributes are created correctly, however, if I use the same statement across a linked server, my identity column loses its IDENTITY specification. Is this a known issue or basic functionality of using "select into" with linked servers? Kurt
2
3363
by: Thirsty Traveler | last post by:
I have an xml column in a SQL Server 2005 table that was populated with a DataSet. I would like to read that column back into a DataSet object but am not quire sure how. Any ideas?
6
16173
by: phnimx | last post by:
I'm attempting to migrate a predominately MFC application that I've just inherited from Visual Studio.NET 2003 to Visual Studio 2005. I've managed to clean up a myriad of compile and link errors but I'm stuck on one final problem. Please note that this application compiled/linked and ran just fine out of Visual Studio.NET 2003. Details: It's originally incarnated as an MFC app, i.e. CWinApp, CMultiDocTemplate,
16
4909
by: Omar Abid | last post by:
Hi every body, Im using VB 2005 to create a program that open SQL Data base The problem that i want to detect the tables of a database so how can i know a data base tables instantly Thank you omar.abid@hotmail.com omar.abid2006@gmail.com Omar abid
0
1360
by: Desmodromic | last post by:
Within the SQL Server 2005 BI product suite, where should metadata be held regarding database objects for reporting? What I mean is if a user is presented with a field called "start_date" then a definition of what exactly "start_date" means should be provided on screen to the user. I am hoping to be able to create a single central respository which can be sourced by all tools - Excel, Analysis Services, Reporting Services, SQL Server...
2
2428
by: smileprince00 | last post by:
what are metadata fnctions....how they can help the programming thank you regards rohit
0
8866
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8781
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8550
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7385
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6192
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5663
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4198
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4366
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2011
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.