-
August 13th, 2006, 12:53 AM
#1
Command to describe a table in sql server
In Oracle we are using desc command to describe a table(to show the fields and its datatype). But in SQL Server, which command we can use to describe a table? Thanks in advance.
-
August 13th, 2006, 06:38 AM
#2
Re: Command to describe a table in sql server
This should have been posted in the Database forum.
There is a view INFROMATION_SCHEMA.COLUMNS that can be used to get the Column desccriptions of a specific table. A query like this will give the details that DESC command does in ORacle
PHP Code:
Select * From INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME = 'TABLENAME'
@Mods : Could this be moved to the Database Forum.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|