How to view the structure of the table in SQL Server
What is the latest version of SQL Server 2000
Printable View
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