PHWinfo - Afficher un message - How do I view table information such as constraints?

19/09/2007, 10h40

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 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 me?

19/09/2007, 10h40	#1
ben_cameron00@hotmail.com Messages: n/a Hébergeur:	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 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 me?