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

Answer Posted / anil panwar

SP_help < table_name>

Is This Answer Correct ?    54 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to return the date part only from a sql server datetime datatype?

771


How to insert data into an existing table?

715


Can we shrink data file in sql server?

757


What is the default port for SQL Server over a firewall?

782


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

794






Why do we use stored procedures in sql server?

677


Explain steps of normalization?

717


How do we know if any query is retrieving a large amount of data or very little data?

730


What is dml command?

713


Where do we use trace frag?

731


When do you think a developer should use sql server-based cursors?

720


What are clustered and non-clustered index?

713


What is the use of =,==,=== operators?

770


How do I find the default sql server instance?

695


Explain “not null constraint” in sql server?

720