Table columns

[netnatter]

My asp.net pages allow the user to add additional columns to an SQL table

Is there an SQL statement that I can use to return the number of columns
that the table currently has?

Netnatter

[Alex Meleta]

Hi netnatter,

Starting investigation from 'SELECT COUNT(*) FROM <table>' might be a good
point.

Regards, Alex Meleta
[TechBlog] http://devkids.blogspot.com

My asp.net pages allow the user to add additional columns to an SQL
table

Is there an SQL statement that I can use to return the number of
columns that the table currently has?

Netnatter

[Mark Rae [MVP]]

"Alex Meleta" <am*****@gmail.comwrote in message
news:df*************************@news.microsoft.co m...

Starting investigation from 'SELECT COUNT(*) FROM <table>' might be a good
point.

How will that help the OP to return the number of *COLUMNS* in his
datatable...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"netnatter" <ne*******@ntlworld.comwrote in message
news:TV*******************@newsfe03.ams2...

Is there an SQL statement that I can use to return the number of columns
that the table currently has?

SELECT
COUNT (*) AS intColumns
FROM
sys.tables AS t
INNER JOIN sys.columns AS c ON t.object_id = c.object_id
WHERE
t.name = '<table>'
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Hans Kesting]

After serious thinking netnatter wrote :

My asp.net pages allow the user to add additional columns to an SQL table

Is there an SQL statement that I can use to return the number of columns that
the table currently has?

Netnatter

SELECT * FROM <tableWHERE 1=0

this doesn't return any rows, but does return the structure of the
table. Fill a DataSet with it and you can investigate the Columns.

Hans Kesting