Answer / anil panwar

SP_help < table_name>

Answer / vidit tyagi

sp_help <tablename>

Answer / krishnaraj

sp_help '<TABLE NAME>'

Answer / erwin suryana

sp_columns <table_name>

Answer / ram

sp_help <table name>

Answer / sathish

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

Select * from information_schema.columns where table_name =
xyz

Answer / r.rajesh

sp_columns table_name

Answer / sagar

Select TableName and then press ALT+F1 means highlight tablename

Answer / murli manohar

sp_tables @table_type = "'TABLEName'"

Answer / justus

sp_helptext <tablename>

What is the difference between drop table and truncate table?

0 Answers  

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

What are joins in sql and what are the different types of joins?

0 Answers  

How to list all stored procedures in the current database using ms sql server?

0 Answers  

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

Differentiate between a primary key and a unique key.

0 Answers  

Explain log shipping?

0 Answers  

How to connect to a sql server using odbc_connect()?

0 Answers  

What is plan freezing?

0 Answers  

What is 3nf normalization?

0 Answers  

What is attribute? : sql server analysis services, ssas

0 Answers