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

Tell me when is the update_statistics command used?

695


Why normalization is used?

726


Explain having clause?

725


How do you create a data source?

649


How to list all tables in the database using odbc_tables()?

752






Do you know what is sql service broker?

717


Does a server store data?

669


What is the difference between dropping a database and taking a database offline?

905


What is similarity and difference between truncate and delete in sql?

767


What is shared lock?

646


Explain different forms of normalization?

685


Is a primary key unique?

702


Do you know what are the properties of the relational tables?

786


Explain use of expression builder.

739


How to choose all records from the table?

794