Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 i need help

Author  Topic 

praveenkumar.kandula
Starting Member

4 Posts

Posted - 2008-04-03 : 01:43:05
hai


how can i get the 'Table Definition' by using a query like

we can get the proc defition by using sp_helptext proc_name........

thanks and regards
praveen

ranganath
Posting Yak Master

209 Posts

Posted - 2008-04-03 : 01:50:32
Hi,

sp_Help TableName
Go to Top of Page

praveenkumar.kandula
Starting Member

4 Posts

Posted - 2008-04-03 : 02:13:45
that displays the details about the table but i need the text of the table
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-04-03 : 02:37:59
From SSMS make use of Generate Script option
or try http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53007

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -