how can i view structure of table in sql server? tell me
that query.

Answer Posted / sathish

how can i view structure of table in sql server? tell me
that query.

Select * from information_schema.columns where table_name =
xyz

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where are sql server usernames and passwords stored in the sql server?

824


How to verify a user name with sqlcmd tool?

817


What are the advantages of using a stored procedure?

735


How do I view a trc file?

710


How does a profiler work?

681


Write an sql query for deleting duplicate rows?

746


Why main is user defined function?

778


What do you understand by check constraint in sql server?

677


How many databases Microsoft SQL server provides?

808


how to do partition in sqlserver

2169


How do indexes help, types?

742


What happens if strings are casted into wrong code pages in ms sql server?

856


What is difference between createstatement and preparedstatement?

823


What is raid and what are different types of raid levels?

812


What are different types of roles provided by ssrs?

128