How to view the structure of the table in SQL Server
What is the latest version of SQL Server 2000
How to view the structure of the table in SQL Server
What is the latest version of SQL Server 2000
sp_help
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(if we want 2 see the total data& structure of the table)
select...from where
(if selected item)
08-08-2007 #10Junior Member
- Join Date
- Apr 2007
- Answers
- 6
Re: How to view the structure of the table
sp_helpwill help you to get the table structure
08-08-2007 #11Re: How to view the structure of the table
hey will
desc table_name not help this out?
08-13-2007 #12Re: How to view the structure of the table
You see the table structure using SP_HELP..
sp_help table_name
09-04-2007 #13Junior Member
- Join Date
- Feb 2007
- Answers
- 6
Re: How to view the structure of the table
my friends is it work?
desc
11-26-2007 #14Junior Member
- Join Date
- Apr 2007
- Answers
- 1
Re: How to view the structure of the table
exec SP_help
11-26-2007 #15Junior Member
- Join Date
- Sep 2007
- Answers
- 10
Re: How to view the structure of the table
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