SELECT top 5 * from information_schema.columns where table

How to select top 5 coloumn from a table without using
coloumn name

Question Posted / aashish arora

Answer Posted / aashish arora

SELECT top 5 * from information_schema.columns where
table_name = 'varTableName'

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain about Joins?

1037

What are different types of collation sensitivity?

1025

How do you know if sql server is running on your local system?

1099

Define normalisation?

1155

Where is localdb stored?

992

How many cores do I need for sql server 2016?

952

What is bit data type? What's the information that can be stored inside a bit column?

969

Why I am getting this error when dropping a database in ms sql server?

1120

How to attach adventureworkslt physical files to the server?

1160

How to transfer a table from one schema to another?

1045

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1941

What do you understand by integration services in sql server?

1002

How is sql used in sql server?

1058

What is primary key and example?

998

How to write an inner join with the where clause in ms sql server?

1166