Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How could you know how many columns you have in your table
- Thread starter CDuffy
- Start date
try this one...
declare @tbl varchar(50)
set @tbl = 'Tablename'
select NumberOfColumns = count(name) from syscolumns where id = (select id from sysobjects where name = @tbl)
or this...
declare @tbl varchar(50)
set @tbl = 'Tablename'
select NumberOfColumns = info from sysobjects where name = @tbl
Andel
andelbarroga@hotmail.com
declare @tbl varchar(50)
set @tbl = 'Tablename'
select NumberOfColumns = count(name) from syscolumns where id = (select id from sysobjects where name = @tbl)
or this...
declare @tbl varchar(50)
set @tbl = 'Tablename'
select NumberOfColumns = info from sysobjects where name = @tbl
Andel
andelbarroga@hotmail.com
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
