How to view the structure of the table

How to view the structure of the table in SQL Server
What is the latest version of SQL Server 2000

sp_help <table_name>

is used to view table structure

latest version of SQL SERVER 2000 is SQL Server 2005

type and highlight the table name in query analyzer and do alt+F1

till date latest version of SQL SERVER is version 2005.

write view name in from clause.

dear pandyaudit

please go through the original question and try to understand it before posting. Here the user asking for the structure not for data ,cwhich has already been answered. Be careful regarding this in future post.

MODERATOR

Hi subashini,
For SQL 2000 server you can view all the diagrams of tables.Go to Enterprise Manager, find the database, find the table then click on table diagram. Hope you u will get it. And MS SLQ 2005 is the latest from Microsoft.

Thanks & Regards,
M.A.Raafay.

using SP_HELP we can get it all the informations about the table..

select * from <table name>(if we want 2 see the total data& structure of the table)
select <field name1><field name2>...from <table name> where <condition>(if selected item)

sp_help <table name> will help you to get the table structure

hey will
desc table_name not help this out?

You see the table structure using SP_HELP..

sp_help table_name

my friends is it work?

desc <table_name>

[QUOTE=Subashini.Ramasamy;14493]How to view the structure of the table in SQL Server
What is the latest version of SQL Server 2000[/QUOTE]
exec SP_help <Table Name>

There are three levels in a DBMS i.e SQL
a) External
b)Conceptual
c)Internal

I guess ur question might be related to second level i.e conceptual.
For that u can do one thing
type this query
select *from tablename

or
ur question might be related to third level i.e internal
for that u can take the help to sql tool Enterprise Manager


Latest version of sql : SQL Server 2005