query to get column names of particular table using sqlserver 2000
select name from SYSCOLUMNS where id=(select id from SYSOBJECTS where name='tablename')
SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs
Showing posts with label query to get column names of particular table. Show all posts
Showing posts with label query to get column names of particular table. Show all posts
Subscribe to:
Posts (Atom)