473,385 Members | 2,274 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

How do I view table information such as constraints?

I remember once using a command in Query Analyser that gave me all the
information about a table. It showed details about the columns,
constraints, keys, indexes etc.

I can't remember how I did this? Can anyone help me?

It could of been a stored proc that I called or a query on the system
tables.

I do know that it was very simple to do and it was executed in Query
Analyser.

Can anyone help me?

Sep 19 '07 #1
2 21539
EXEC sp_help tablename

Roy Harvey
Beacon Falls, CT

On Wed, 19 Sep 2007 01:40:49 -0700, be***********@hotmail.com wrote:
>I remember once using a command in Query Analyser that gave me all the
information about a table. It showed details about the columns,
constraints, keys, indexes etc.

I can't remember how I did this? Can anyone help me?

It could of been a stored proc that I called or a query on the system
tables.

I do know that it was very simple to do and it was executed in Query
Analyser.

Can anyone help me?
Sep 19 '07 #2
On Sep 19, 11:24 pm, "Roy Harvey (MVP)" <roy_har...@snet.netwrote:
EXEC sp_help tablename

Roy Harvey
Beacon Falls, CT

On Wed, 19 Sep 2007 01:40:49 -0700, ben_camero...@hotmail.com wrote:
I remember once using a command in Query Analyser that gave me all the
information about a table. It showed details about the columns,
constraints, keys, indexes etc.
I can't remember how I did this? Can anyone help me?
It could of been a stored proc that I called or a query on the system
tables.
I do know that it was very simple to do and it was executed in Query
Analyser.
Can anyone help me?- Hide quoted text -

- Show quoted text -
Thanks, thats what I was after.

Sep 26 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Bernard André | last post by:
Hi All, context: I am using Access 97 tablkes with VB. I can see records in the MDB, using Adodc and datagrid. No problem. But when doing: rsprivate.AddNew rsprivate!For =...
3
by: valexena | last post by:
Which Oracle dictionary view gives information about the position of a column in a primary key? -- Posted via http://dbforums.com
2
by: WertmanTheMad | last post by:
MVP's and the like I am looking for suggestions , confirmation Let me start by saying bar none, performance is paramount with the queries to be retured off this view/table query. To that...
0
by: crack4u | last post by:
How can i collect table information wich i can reuse in a new sql ie select all colomnheaders from table1 (and use this info in a dropdownlist) select columnheader1 from table1. Is there a...
4
by: xeqister | last post by:
Greetings, I would like to know whether there is a way to estimate/calculate the view table size in DB2. As what I understand, view is just a logical table and we cannot simply calculate the size...
0
by: Gancy | last post by:
Hi, I have data access tier designed in such a way, just by changnging application settings, same lines of code is made to work with both MS SQL Server or MS Access. Code works fine with MS SQL...
2
by: NowItsWhatever | last post by:
In query DESIGN view, how do I automatically "fit" the columns in the table/field grid to the lengths of the table and field names (including any functions applied to the fields). I am not talking...
4
by: G .Net | last post by:
Hi I have a DataSet with several DataTables. I have set up relations between these tables. I want to delete all the tables and re-fill them. However, when I try to do so, even after using...
6
by: antonyliu2002 | last post by:
I was able to view table content easily before, but after I reinstalled everything, I cannot find the option to view table content in MS SQL Server Express. I can define table with no problem. ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...

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.